-------------------------------------------------------------------------------------------------------------------------------------
       log:  /hmt/hpcstorage1/hpc/sscc/work/projects/ccm/CCM/CCM-RAND_for_posting_on_Dataverse/log_files/clean_data_log.log
  log type:  text
 opened on:  17 Jul 2011, 15:37:06

. /*********************************************************************************************************************
> *
> * This do file cleans the raw data on accidental deaths variables, tort reform variables, and control variables,
> * generating new variables that are used in the regressions for the JSL and accidental deaths paper.    
> * The dataset produced by this do file has all of the variables that are used to run the regressions
> * in the paper.  
> * 
> * Program by Dan Carvell, written between Summer 2007 and Spring 2010.  
> *
> *********************************************************************************************************************/
> 
>  
>  
> 
> use "/hmt/hpcstorage1/hpc/sscc/work/projects/ccm/CCM/CCM-RAND_for_posting_on_Dataverse/data/raw_state_year_data/Raw_Data_Deaths.dta
> ", clear;

. /* CREATING NEW VARIABLES FOR THE REGRESSIONS  */
> 
> /* First, create statefip indicators and state specific time trends for the regressions */
> 
> 
> /* state-specific time trends */
> 
> capture drop sy*;

. gen sy1=    (statefip==1)*(year-1981);

. gen sy2=        (statefip==2)*(year-1981);

.            gen sy4=     (statefip==4)*(year-1981);

.            gen sy5=     (statefip==5)*(year-1981);

.            gen sy6=     (statefip==6)*(year-1981);

.            gen sy8=     (statefip==8)*(year-1981);

.            gen sy9=     (statefip==9)*(year-1981);

.            gen sy10=    (statefip==10)*(year-1981);

.            gen sy11=    (statefip==11)*(year-1981);

.            gen sy12=    (statefip==12)*(year-1981);

.            gen sy13=    (statefip==13)*(year-1981);

.            gen sy15=    (statefip==15)*(year-1981);

.            gen sy16=    (statefip==16)*(year-1981);

.            gen sy17=    (statefip==17)*(year-1981);

.            gen sy18=    (statefip==18)*(year-1981);

.            gen sy19=    (statefip==19)*(year-1981);

.            gen sy20=    (statefip==20)*(year-1981);

.            gen sy21=    (statefip==21)*(year-1981);

.            gen sy22=    (statefip==22)*(year-1981);

.            gen sy23=    (statefip==23)*(year-1981);

.            gen sy24=    (statefip==24)*(year-1981);

.            gen sy25=    (statefip==25)*(year-1981);

.            gen sy26=    (statefip==26)*(year-1981);

.            gen sy27=    (statefip==27)*(year-1981);

.            gen sy28=    (statefip==28)*(year-1981);

.            gen sy29=    (statefip==29)*(year-1981);

.            gen sy30=    (statefip==30)*(year-1981);

.            gen sy31=    (statefip==31)*(year-1981);

.            gen sy32=    (statefip==32)*(year-1981);

.            gen sy33=    (statefip==33)*(year-1981);

.            gen sy34=    (statefip==34)*(year-1981);

.            gen sy35=    (statefip==35)*(year-1981);

.            gen sy36=    (statefip==36)*(year-1981);

.            gen sy37=    (statefip==37)*(year-1981);

.            gen sy38=    (statefip==38)*(year-1981);

.            gen sy39=    (statefip==39)*(year-1981);

.            gen sy40=    (statefip==40)*(year-1981);

.            gen sy41=    (statefip==41)*(year-1981);

.            gen sy42=    (statefip==42)*(year-1981);

.            gen sy44=    (statefip==44)*(year-1981);

.            gen sy45=    (statefip==45)*(year-1981);

.            gen sy46=    (statefip==46)*(year-1981);

.            gen sy47=    (statefip==47)*(year-1981);

.            gen sy48=    (statefip==48)*(year-1981);

.            gen sy49=    (statefip==49)*(year-1981);

.            gen sy50=    (statefip==50)*(year-1981);

.            gen sy51=    (statefip==51)*(year-1981);

.            gen sy53=    (statefip==53)*(year-1981);

.            gen sy54=    (statefip==54)*(year-1981);

.            gen sy55=    (statefip==55)*(year-1981);

.            gen sy56=    (statefip==56)*(year-1981);

. /* state-specific time trend macro */
> global sy "sy2 sy4-sy6 sy8-sy13 sy15-sy42 sy44-sy51 sy53-sy56";

. /* Generate state Fixed Effects variables */
> 
> capture drop st1 st2 st4 st5 st6 st8 st9 st10 st11 st12 st13 st15 st16 st17 st18 st19 st20 st21 st22 st23 st24 st25 st26 st27 st28 
> st29 st30 st31 st32 st33 st34 st35 st36 st37 st38 st39 st40 st41 st42 st44 st45 st46 st47 st48 st49 st50 st51 st53 st54 st55 st56;

. /* I couldn't have written capture drop st* there, as that would drop variables like statefip and so forth */  
> 
> gen st1=    (statefip==1);

. gen st2=        (statefip==2);

.            gen st4=     (statefip==4);

.            gen st5=     (statefip==5);

.            gen st6=     (statefip==6);

.            gen st8=     (statefip==8);

.            gen st9=     (statefip==9);

.            gen st10=    (statefip==10);

.            gen st11=    (statefip==11);

.            gen st12=    (statefip==12);

.            gen st13=    (statefip==13);

.            gen st15=    (statefip==15);

.            gen st16=    (statefip==16);

.            gen st17=    (statefip==17);

.            gen st18=    (statefip==18);

.            gen st19=    (statefip==19);

.            gen st20=    (statefip==20);

.            gen st21=    (statefip==21);

.            gen st22=    (statefip==22);

.            gen st23=    (statefip==23);

.            gen st24=    (statefip==24);

.            gen st25=    (statefip==25);

.            gen st26=    (statefip==26);

.            gen st27=    (statefip==27);

.            gen st28=    (statefip==28);

.            gen st29=    (statefip==29);

.            gen st30=    (statefip==30);

.            gen st31=    (statefip==31);

.            gen st32=    (statefip==32);

.            gen st33=    (statefip==33);

.            gen st34=    (statefip==34);

.            gen st35=    (statefip==35);

.            gen st36=    (statefip==36);

.            gen st37=    (statefip==37);

.            gen st38=    (statefip==38);

.            gen st39=    (statefip==39);

.            gen st40=    (statefip==40);

.            gen st41=    (statefip==41);

.            gen st42=    (statefip==42);

.            gen st44=    (statefip==44);

.            gen st45=    (statefip==45);

.            gen st46=    (statefip==46);

.            gen st47=    (statefip==47);

.            gen st48=    (statefip==48);

.            gen st49=    (statefip==49);

.            gen st50=    (statefip==50);

.            gen st51=    (statefip==51);

.            gen st53=    (statefip==53);

.            gen st54=    (statefip==54);

.            gen st55=    (statefip==55);

.            gen st56=    (statefip==56);

. global st "st2 st4-st6 st8-st13 st15-st42 st44-st51 st53-st56";

. /* Generate new variables for the presence of tort reforms in each state, variables that will be used in the regressions  */
> 
> 
> /* The prefix o_ in front of a tort reform variable means that the tort reform applies in tort suits in general - in tort   */
> /* suits other than medical malpractice cases, as well as in medical malpractice cases                                      */
> /* The prefix m_ in front of a tort reform variable means that the tort reform applies in medical malpractice cases -       */
> /* it may or may not be specific to medical malpractice, though.  If the o_ tort reform variable is equal to 0 in a state   */
> /* in a year, but the m_ tort reform variable is not, then a tort reform is in place that only applies in medical           */
> /* malpractice cases                                                                                                        */
> 
> 
> 
> 
> 
> 
> /* Variables for caps on Noneconomic Damages, ie NED caps - in the raw data this is coded as 0 if there is no cap,          */
> /* and as the nominal dollar value of the cap if there is a cap in place - turn these variables into indicator variables    */
> 
> 
> gen o_nedcap_raw=o_nedcap;

. drop o_nedcap;

. gen m_nedcap_raw=m_nedcap;

. drop m_nedcap;

. gen o_nedcap=0;

. replace o_nedcap=1 if o_nedcap_raw!=0;
(137 real changes made)

. label variable o_nedcap "=1 if cap on NED applying in all or most types of tort suits in general is in place";
note: label truncated to 80 characters

. gen m_nedcap=0;

. replace m_nedcap=1 if m_nedcap_raw!=0;
(400 real changes made)

. /* The m_dcap variable is for the presence of a cap on total damages, both economic and noneconomic, that applies       */
> /* in medical malpractice suits.  This also must be turned into an indicator variable, and later in this do file        */
> /* when variables for the presence of caps on NED that are specific to medical malpractice are generated, these caps    */
> /* on total damages will counted as caps on NED for the purpose of generating the variable for caps on NED that are     */
> /* specific to med mal                                                                                                  */
> 
> gen m_dcap_raw=m_dcap;

. drop m_dcap;

. gen m_dcap=0;

. replace m_dcap=1 if m_dcap_raw!=0;
(102 real changes made)

. /* Create variables for the presence of a JSL reform                                                                               
>                  */
> /* The variable equals 1 if a JSL reform of any type is in place - that is because in our theoretical model, a solvent tortfeasor h
> as an incentive  */
> /* to bring a judgment proof co-tortfeasor into the case regardless of what the cutoff in the particular JSL reform is, the cutoff 
> being the        */
> /* percentage threshold below which a tortfeasor is severally liable, and above which the tortfeasor is liable for the entirety of 
> the damages      */
> 
> 
> gen o_jsl_0=0;

.  replace o_jsl_0=1 if [o_jsled>0 | o_jslned>0];
(716 real changes made)

. label variable o_jsl_0 " =1 iff [o_jsled>0 | o_jslned>0], ie a JSL reform is in place";

. gen m_jsl_0=0;

.  replace m_jsl_0=1 if [m_jsled>0 | m_jslned>0];
(562 real changes made)

. /* Create variable for the presence of a JSL reform that applies in all tort suits over auto accidents -               */
> /* Hawaii's does not apply to most tortfeasors in auto accidents, with the one exception being that it applies         */
> /* to a government agency that maintains the road if the agency did not have reasonable prior notice that a feature    */
> /* of the road had led to a prior auto accident under similar circumstances.                                           */
> /* Michigan's JSL reform does not apply to drunk driver tortfeasors                                                    */
> /* Pennsylvania's JSL reform does not apply to businesses that sell or give alcohol to visibly intoxicated customers   */
> /* who go on to injure third parties when they are intoxicated.                                                        */
> 
> 
> 
> generate o_jsl_0_auto=o_jsl_0;

. ** Hawaii, statefip 15;
. replace o_jsl_0_auto=0 if statefip==15;
(19 real changes made)

. ** Michigan, statefip 26;
. replace o_jsl_0_auto=0 if statefip==26;
(19 real changes made)

. ** Pennsylvania, statefip 42;
. replace o_jsl_0_auto=0 if statefip==42;
(2 real changes made)

. /* CSR Reform Variables */
> 
> /* Variable definitions for the CSR variables in the raw data - */
> 
> /* o_csr and m_csr indicate the presence of CSR reforms that allow tort awards to be offset by payments from private collateral sou
> rces,  */
> /* such as private health insurance.  o_csrp and m_csrp indicate the presence of CSR reforms that allow tort awards to be offset by
>        */
> /* payments from public collateral sources, such as publicly provided health insurance.  Although both of these types of variables 
> are    */
> /* in the raw data, in this paper, we only study the effects of CSR reforms that allow awards to be offset by payments from private
>        */
> /* collateral sources, since private insurance is so common, and so that these reforms should have larger effects.  However, during
>  the   */
> /* time period we study, only one state (Colorado) enacts a CSR reform that applies in tort suits in general, not just medical     
>        */
> /* malpractice cases, and that only allows offsets of payments from public collateral sources, and not private ones.  None of the s
> tates  */
> /* strike down or repeal such reforms                                                                                              
>        */
> 
> /* The suffix _off indicates that the CSR reform requires tort awards to be offset by collateral source payments.  The suffix _ev  
>        */
> /* indicates that a CSR reform is in place that allows tort awards to be offset by collateral source payments at the discretion of 
> the    */
> /* trier of fact in the case.  Since the latter type of CSR reform is uncommon, however, I group these two types of reforms togethe
> r in   */
> /* the CSR reform variable used in the regressions                                                                                 
>        */
> 
> 
> 
> label variable o_csr_off "=1 iff mandatory offset CSR reform";

. label variable o_csr_ev "=1 iff discretionary offset CSR reform";

. label variable m_csr_off "=1 iff mandatory offset CSR reform";

. label variable m_csr_ev "=1 iff discretionary offset CSR reform";

. gen o_csr=0;

. replace o_csr=1 if (o_csr_off==1 | o_csr_ev==1);
(239 real changes made)

. gen m_csr=0;

. replace m_csr=1 if (m_csr_off==1 | m_csr_ev==1);
(462 real changes made)

. label variable o_csr "any generally applicable CSR reform, mandatory or discretionary";

. label variable m_csr "any CSR reform that applies in med mal cases, mandatory or discretionary";

. /* Generate variables for the presense of tort reforms that are specific to medical malpractice - i.e. reforms that only apply in m
> ed mal suits  */
> 
> 
> 
> /* In the paper, we only ended up studying the effects of NED caps that are specific to med mal, as it's rare for other types of to
> rt reforms    */
> /* besides NED caps to be specific to med mal.  A few states have caps on total damages, both noneconomic and economic, that apply 
> only in med   */
> /* mal suits.  We consider these caps on total damages to be equivalent to NED caps, as both types of caps are strong caps that ser
> ve the same   */
> /* purpose.  So in order to generate the variable for caps on NED that are specific to med mal, I need to replace the variable m_ne
> dcap with 1   */
> /* when a cap on total damages applying in med mal claims is in place in a state                                                   
>               */
> 
> 
> replace m_nedcap=1 if (m_dcap==1 | m_nedcap==1);
(84 real changes made)

. gen m_nedcap_2=m_nedcap;

. gen o_nedcap_2=o_nedcap;

. gen mms_nedcap= m_nedcap - o_nedcap;

. replace mms_nedcap=0 if (m_nedcap==0 & o_nedcap==1);
(0 real changes made)

. label variable mms_nedcap "=1 iff there is a cap on NED that is specific to med mal";

. /* We also have variables for no-fault auto insurance to use as controls in the regressions with auto accidents as the dependent va
> riable     */
> /* There are two basic types of no-fault auto insurance laws - regular no-fault auto insurance, in which tort liability is replaced
>  with      */
> /* no-fault first party compensation for auto accidents in which damages fall below a certain threshold, and add-on auto insurance,
>  in which  */
> /* accident victims receive compensation for their own harms from their own insurer, but face no restrictions on their right and ab
> ility to   */
> /* sue other drivers to recover even more compensation.  The coding of the two variables for no-fault auto in the raw data reflects
>  these     */
> /* distinctions.  However, I also need to generate a variable indicating the presence of any kind of no-fault auto insurance law, e
> ither      */
> /* regular or add-on                                                                                                               
>            */
> 
> 
> 
> 
> generate no_fault_auto_any=0;

. replace no_fault_auto_any=1 if (no_fault_auto_add_on==1 | no_fault_auto_regular==1);
(642 real changes made)

. /* Now, I need to make variables for the presence of "New" and "Old" Tort reforms - variables for new tort reforms that were enacte
> d    */
> /* within the last 2, 3, or 4 years, and variables for old tort reforms that have been in place for more than 2, 3, or 4 years     
>      */
> /* Making all of these variables takes many lines of commands, and is a large component of this do file                            
>      */
> 
> 
> 
> 
> /* First, I am making the NED cap variables.  Recall that the variable o_nedcap_enact gives the year in which the NED cap was enact
> ed,  */
> /* for state-year observations with an NED cap in place.  The difference between the current year and o_nedcap_enact gives the numb
> er   */
> /* of years that the NED cap has been in place for                                                                                 
>      */
> 
> 
> gen o_ned_year= year - o_nedcap_enact;
(1138 missing values generated)

. /* The suffix _yr2 on these variables means the reform has been in place for more than 2 years    */
> 
> gen o_nedcap_yr2=0;

. replace o_nedcap_yr2=1 if (o_nedcap==1 & o_ned_year>1 & o_ned_year!=.);
(115 real changes made)

. gen m_ned_year= year - m_nedcap_enact;
(875 missing values generated)

. gen m_nedcap_yr2=0;

. replace m_nedcap_yr2=1 if (m_nedcap==1 & m_ned_year>1 & m_ned_year!=.);
(349 real changes made)

. ** Make mms_nedcap_yr2 from these two new variables;
. gen mms_nedcap_yr2= m_nedcap_yr2 - o_nedcap_yr2;

. replace mms_nedcap_yr2=0 if (m_nedcap_yr2==0 & o_nedcap_yr2==1);
(0 real changes made)

. ** Now the indicators for if there is a reform that has been in place for 0 or 1 years;
. gen o_nedcap_new=0;

. replace o_nedcap_new=1 if (o_nedcap==1 & (o_ned_year==1 | o_ned_year==0));
(22 real changes made)

. gen m_nedcap_new=0;

. replace m_nedcap_new=1 if (m_nedcap==1 & (m_ned_year==1 | m_ned_year==0));
(51 real changes made)

. gen mms_nedcap_new= m_nedcap_new - o_nedcap_new;

. replace mms_nedcap_new=0 if (m_nedcap_new==0 & o_nedcap_new==1);
(1 real change made)

. /* Create other variables for new and old reforms, looking at the effects of the law in the first 3 or 4 years vs. after year 3 or 
> 4  */
> 
> 
> gen o_nedcap_yr3=0;

. replace o_nedcap_yr3=1 if (o_nedcap==1 & o_ned_year>2 & o_ned_year!=.);
(105 real changes made)

. gen m_nedcap_yr3=0;

. replace m_nedcap_yr3=1 if (m_nedcap==1 & m_ned_year>2 & m_ned_year!=.);
(327 real changes made)

. gen o_nedcap_yr4=0;

. replace o_nedcap_yr4=1 if (o_nedcap==1 & o_ned_year>3 & o_ned_year!=.);
(97 real changes made)

. gen m_nedcap_yr4=0;

. replace m_nedcap_yr4=1 if (m_nedcap==1 & m_ned_year>3 & m_ned_year!=.);
(309 real changes made)

. gen mms_nedcap_yr3= m_nedcap_yr3 - o_nedcap_yr3;

. replace mms_nedcap_yr3=0 if (m_nedcap_yr3==0 & o_nedcap_yr3==1);
(0 real changes made)

. gen mms_nedcap_yr4= m_nedcap_yr4 - o_nedcap_yr4;

. replace mms_nedcap_yr4=0 if (m_nedcap_yr4==0 & o_nedcap_yr4==1);
(0 real changes made)

. ** Now the indicators for if the reform has been in place for only 2 or 3 years, i.e. enacted within the last 3 or 4 years;
. gen o_nedcap_new3=0;

. replace o_nedcap_new3=1 if (o_nedcap==1 & (o_ned_year>=0 &  o_ned_year<=2));
(32 real changes made)

. gen m_nedcap_new3=0;

. replace m_nedcap_new3=1 if (m_nedcap==1 & (m_ned_year>=0 & m_ned_year<=2));
(73 real changes made)

. gen mms_nedcap_new3= m_nedcap_new3 - o_nedcap_new3;

. replace mms_nedcap_new3=0 if (m_nedcap_new3==0 & o_nedcap_new3==1);
(0 real changes made)

. gen o_nedcap_new4=0;

. replace o_nedcap_new4=1 if (o_nedcap==1 & (o_ned_year>=0 & o_ned_year<=3));
(40 real changes made)

. gen m_nedcap_new4=0;

. replace m_nedcap_new4=1 if (m_nedcap==1 & (m_ned_year>=0 & m_ned_year<=3));
(91 real changes made)

. gen mms_nedcap_new4= m_nedcap_new4 - o_nedcap_new4;

. replace mms_nedcap_new4=0 if (m_nedcap_new4==0 & o_nedcap_new4==1);
(0 real changes made)

. /* Generate two-year leads of the NED cap variables - variables equal 1 in the two years before the reform gets enacted, and are 0 
> otherwise   */
> /* The variable o_nedcap_enact_lead states the year in which a reform that will be enacted in the future is enacted                
>             */
> 
> 
> gen o_nedcap_year_lead=o_nedcap_enact_lead - year;
(1177 missing values generated)

. gen o_nedcap_lead_2=0;

. replace o_nedcap_lead_2=1 if (o_nedcap_year_lead==1 | o_nedcap_year_lead==2);
(24 real changes made)

. gen m_nedcap_year_lead=m_nedcap_enact_lead - year;
(1019 missing values generated)

. gen m_nedcap_lead_2=0;

. replace m_nedcap_lead_2=1 if (m_nedcap_year_lead==1 | m_nedcap_year_lead==2);
(52 real changes made)

. gen mms_nedcap_lead_2=0;

. replace mms_nedcap_lead_2=1 if (o_nedcap_lead_2==0 & m_nedcap_lead_2==1);
(31 real changes made)

. /* Variables for new and old Punitive Damages Reforms - in the paper we use a composite Punitive Damages Reform variable that equal
> s 1 if either  */
> /* a Punitive Damages Cap or a Punitive Damages Evidence reform is in place - but I've left the commands to create variables for ne
> w and old      */
> /* PD caps and PD reforms in this program, in case they are of any use in the future, and as they've already been written          
>                */
> 
> 
> 
> gen o_pd_year= year - o_pdcap_enact;
(876 missing values generated)

. gen o_pdcap_yr2=0;

. replace o_pdcap_yr2=1 if (o_pdcap==1 & o_pd_year>1 & o_pd_year!=.);
(356 real changes made)

. gen o_pdcap_new=0;

. replace o_pdcap_new=1 if (o_pdcap==1 & (o_pd_year==1 | o_pd_year==0));
(43 real changes made)

. /* Now 3 and 4 years rather than 2 years as the cutoff between new and old reforms  */
> 
> gen o_pdcap_yr3=0;

. replace o_pdcap_yr3=1 if (o_pdcap==1 & o_pd_year>2 & o_pd_year!=.);
(338 real changes made)

. gen o_pdcap_new3=0;

. replace o_pdcap_new3=1 if (o_pdcap==1 & (o_pd_year>=0 & o_pd_year<=2));
(61 real changes made)

. gen o_pdcap_yr4=0;

. replace o_pdcap_yr4=1 if (o_pdcap==1 & o_pd_year>3 & o_pd_year!=.);
(323 real changes made)

. gen o_pdcap_new4=0;

. replace o_pdcap_new4=1 if (o_pdcap==1 & (o_pd_year>=0 & o_pd_year<=3));
(76 real changes made)

. /* Generate 2 - year leads of the PD Cap variables    */
> 
> 
> gen o_pdcap_year_lead=o_pdcap_enact_lead - year;
(999 missing values generated)

. gen o_pdcap_lead_2=0;

. replace o_pdcap_lead_2=1 if (o_pdcap_year_lead==1 | o_pdcap_year_lead==2);
(46 real changes made)

. /*  Now, create variables for new and old PD Evidence reforms, and the leads of the PD Evidence Reform variables   */
> 
> 
> gen o_pdev_year= year - o_pd_ev_enact;
(763 missing values generated)

. gen o_pdev_yr2=0;

. replace o_pdev_yr2=1 if (o_pdev==1 & o_pdev_year>1 & o_pdev_year!=.);
(450 real changes made)

. gen o_pdev_new=0;

. replace o_pdev_new=1 if (o_pdev==1 & (o_pdev_year==1 | o_pdev_year==0));
(62 real changes made)

. /* Now 3 and 4 years rather than 2 years as the cutoff between new and old reforms  */
> 
> 
> 
> 
> gen o_pdev_yr3=0;

. replace o_pdev_yr3=1 if (o_pdev==1 & o_pdev_year>2 & o_pdev_year!=.);
(420 real changes made)

. gen o_pdev_new3=0;

. replace o_pdev_new3=1 if (o_pdev==1 & (o_pdev_year>=0 & o_pdev_year<=2));
(92 real changes made)

. gen o_pdev_yr4=0;

. replace o_pdev_yr4=1 if (o_pdev==1 & o_pdev_year>3 & o_pdev_year!=.);
(390 real changes made)

. gen o_pdev_new4=0;

. replace o_pdev_new4=1 if (o_pdev==1 & (o_pdev_year>=0 & o_pdev_year<=3));
(122 real changes made)

. /* Two-year lead of the PD - evidence variable     */
> 
> gen o_pdev_year_lead=o_pd_ev_enact_lead - year;
(962 missing values generated)

. gen o_pdev_lead_2=0;

. replace o_pdev_lead_2=1 if (o_pdev_year_lead==1 | o_pdev_year_lead==2);
(62 real changes made)

. /* Variables for new and old PD Reforms - either a PD Cap or a PD Evidence Reform is in place - and the 2-Year Lead of the PD Refor
> m Variable   */
> 
> 
> gen o_pdr_year= year - o_pd_reform_enact;
(541 missing values generated)

. gen o_pd_reform_yr2=0;

. replace o_pd_reform_yr2=1 if (o_pd_reform==1 & o_pdr_year>1 & o_pdr_year!=.);
(670 real changes made)

. gen o_pd_reform_new=0;

. replace o_pd_reform_new=1 if (o_pd_reform==1 & (o_pdr_year==1 | o_pdr_year==0));
(64 real changes made)

. /* Now 3 and 4 years rather than 2 years as the cutoff between new and old reforms  */
> 
> 
> 
> gen o_pd_reform_yr3=0;

. replace o_pd_reform_yr3=1 if (o_pd_reform==1 & o_pdr_year>2 & o_pdr_year!=.);
(639 real changes made)

. gen o_pd_reform_new3=0;

. replace o_pd_reform_new3=1 if (o_pd_reform==1 & (o_pdr_year>=0 & o_pdr_year<=2));
(95 real changes made)

. gen o_pd_reform_yr4=0;

. replace o_pd_reform_yr4=1 if (o_pd_reform==1 & o_pdr_year>3 & o_pdr_year!=.);
(608 real changes made)

. gen o_pd_reform_new4=0;

. replace o_pd_reform_new4=1 if (o_pd_reform==1 & (o_pdr_year>=0 & o_pdr_year<=3));
(126 real changes made)

. /* Lead of the PD-Reform Variable   */ 
> 
> gen o_pdr_year_lead=o_pd_reform_enact_lead - year;
(984 missing values generated)

. gen o_pd_reform_lead_2=0;

. replace o_pd_reform_lead_2=1 if (o_pdr_year_lead==1 | o_pdr_year_lead==2);
(64 real changes made)

. /* Now, create variables for new and old CSR reforms, and the 2-year leads of the CSR reform variable        */
> 
> 
> gen o_csr_year= year - o_csr_enact;
(1036 missing values generated)

. gen o_csr_yr2=0;

. replace o_csr_yr2=1 if (o_csr==1 & o_csr_year>1 & o_csr_year!=.);
(203 real changes made)

. gen o_csr_new=0;

. replace o_csr_new=1 if (o_csr==1 & (o_csr_year==1 | o_csr_year==0));
(36 real changes made)

. /* Now 3 and 4 years rather than 2 years as the cutoff between new and old reforms  */
> 
> 
> 
> gen o_csr_yr3=0;

. replace o_csr_yr3=1 if (o_csr==1 & o_csr_year>2 & o_csr_year!=.);
(186 real changes made)

. gen o_csr_new3=0;

. replace o_csr_new3=1 if (o_csr==1 & (o_csr_year>=0 & o_csr_year<=2));
(53 real changes made)

. gen o_csr_yr4=0;

. replace o_csr_yr4=1 if (o_csr==1 & o_csr_year>3 & o_csr_year!=.);
(170 real changes made)

. gen o_csr_new4=0;

. replace o_csr_new4=1 if (o_csr==1 & (o_csr_year>=0 & o_csr_year<=3));
(69 real changes made)

. /* Two-year lead of the variable        */
> 
> gen o_csr_year_lead=o_csr_enact_lead - year;
(1139 missing values generated)

. gen o_csr_lead_2=0;

. replace o_csr_lead_2=1 if (o_csr_year_lead==1 | o_csr_year_lead==2);
(38 real changes made)

. /* Now, create variables for new and old JSL reforms, and the 2 year lead of the JSL reform variable as well      */
> 
> 
> 
> gen o_jsl_0_year= year - o_jsl_0_enact;
(559 missing values generated)

. /* First, a two-year cutoff between new and old JSL reforms         */
> gen o_jsl_0_new=0;

. replace o_jsl_0_new=1 if (o_jsl_0==1 & (o_jsl_0_year==1 | o_jsl_0_year==0));
(70 real changes made)

. gen o_jsl_0_yr2=0;

. replace o_jsl_0_yr2=1 if (o_jsl_0==1 & o_jsl_0_year>1 & o_jsl_0_year!=.);
(646 real changes made)

. /* Now, a three-year cutoff      */
> 
> gen o_jsl_0_yr3=0;

. replace o_jsl_0_yr3=1 if (o_jsl_0==1 & o_jsl_0_year>2 & o_jsl_0_year!=.);
(612 real changes made)

. gen o_jsl_0_new3=0;

. replace o_jsl_0_new3=1 if (o_jsl_0==1 & (o_jsl_0_year>=0 & o_jsl_0_year<=2));
(104 real changes made)

. /* Now, a four-year cutoff       */
> 
> gen o_jsl_0_yr4=0;

. replace o_jsl_0_yr4=1 if (o_jsl_0==1 & o_jsl_0_year>3 & o_jsl_0_year!=.);
(577 real changes made)

. gen o_jsl_0_new4=0;

. replace o_jsl_0_new4=1 if (o_jsl_0==1 & (o_jsl_0_year>=0 & o_jsl_0_year<=3));
(139 real changes made)

. /* Now, make the two-year lead of the JSL reform variable    */
> 
> 
> gen o_jsl_0_year_lead=o_jsl_0_enact_lead - year;
(992 missing values generated)

. gen o_jsl_0_lead_2=0;

. replace o_jsl_0_lead_2=1 if (o_jsl_0_year_lead==1 | o_jsl_0_year_lead==2);
(69 real changes made)

. /* Now, generate the dependent variables - accidental death rates                       */
> /* Prior drafts of this paper used dependent variables that were logs of accidental     */
> /* death rates - I have kept the commands to make the logs of the dependent varaibles   */
> /* in this do file, to facilitate easy comparison with the earlier drafts               */
> 
> 
> 
> /* generate accidental death rate excluding auto accidents, and the log of this */
> 
> gen deathrate= with_auto_raw - just_auto_raw;
(51 missing values generated)

. gen ln_rate= ln(deathrate);
(51 missing values generated)

. label variable deathrate "nonautomotive accidental death rate per 100,000 residents";

. label variable ln_rate "natural log of deathrate";

. /* Generate log of rate of auto accidents only */
> 
> gen ln_auto_rate= ln(just_auto_raw);
(51 missing values generated)

. label variable ln_auto_rate "log of death rate from auto accidents per 100,000 state residents";

. /* Generate log of rate of overdoses on illegal drugs and abused pharmaceuticals only,       */
> /* as well as the rate of accidents excluding overdoses as well as auto accidents            */
> 
> 
> gen ln_OD_rate = ln(OD_rate);
(51 missing values generated)

. label variable OD_rate "rate of fatal drug overdoses per 100,000 state residents";

. label variable ln_OD_rate "log of rate of fatal drug overdoses per 100,000 state residents";

. gen deathrate_no_OD= with_auto_raw - just_auto_raw - OD_rate;
(51 missing values generated)

. gen ln_rate_no_OD= ln(deathrate_no_OD);
(51 missing values generated)

. label variable deathrate_no_OD "non-auto non-overdose accidental death rate per 100,000 residents";

. label variable ln_rate_no_OD "natural log of deathrate_no_OD";

. sum OD_rate;

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
     OD_rate |      1224    2.547061    2.478156    .097284   16.92163

. sum deathrate_no_OD;

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
deathrate_~D |      1224    19.10507    5.148879   9.833199   65.47523

. ** Generate even more specific accident rate variables for different categories defined by type of accident;
. ** First, fall-related deaths;
. ** This variable is based on a count of falls deaths made with the Vital Stats data;
. ** Falls - here, VS stands for Vital Statistics;
. generate fall_VS_rate= (fall_count_VS/population)*100000;
(51 missing values generated)

. gen ln_fall_VS=ln(fall_VS_rate);
(51 missing values generated)

.     ** Drownings;
. generate drowning_VS_rate= (drowning_count_VS/population)*100000;
(51 missing values generated)

. gen ln_drowning_VS=ln(drowning_VS_rate);
(52 missing values generated)

.     ** Suffocations;
. generate suffocate_VS_rate= (suffocate_count_VS/population)*100000;
(51 missing values generated)

. gen ln_suffocate_VS=ln(suffocate_VS_rate);
(51 missing values generated)

.     ** Fires and burns;
. generate fire_burn_VS_rate= (fire_burn_count_VS/population)*100000;
(51 missing values generated)

. gen ln_fire_burn_VS=ln(fire_burn_VS_rate);
(52 missing values generated)

.     ** Poisonings other than drug overdoses;
. generate poisonNotOD_VS_rate= (poisonNotOD_count_VS/population)*100000;
(51 missing values generated)

. gen ln_poisonNotOD_VS=ln(poisonNotOD_VS_rate);
(75 missing values generated)

.     ** Poisonings by and exposure to other and unspecified solid and liquid substances, which is a subcategory of the poisonings th
> at are not Drug Overdoses;
. generate poisonOther_VS_rate= (poisonOther_count_VS/population)*100000;
(51 missing values generated)

. gen ln_poisonOther_VS=ln(poisonOther_VS_rate);
(176 missing values generated)

.     ** Poisonings by and exposure to gases and vapors, which is another subcategory of the poisonings that are not Drug Overdoses;
. generate poisonGas_VS_rate= (poisonGas_count_VS/population)*100000;
(51 missing values generated)

. gen ln_poisonGas_VS=ln(poisonGas_VS_rate);
(101 missing values generated)

.     ** Transportation accidents other than auto accidents;
. generate o_trnsprt_VS_rate= (o_trnsprt_count_VS/population)*100000;
(51 missing values generated)

. gen ln_o_trnsprt_VS=ln(o_trnsprt_VS_rate);
(54 missing values generated)

.     ** Adverse effects of medical care and pharmaceuticals in therapeutic use;
. generate adverseFX_VS_rate= (adverseFX_count_VS/population)*100000;
(51 missing values generated)

. gen ln_adverseFX_VS=ln(adverseFX_VS_rate);
(51 missing values generated)

.     ** Cut and pierce injury accidents;
. generate cut_prc_VS_rate= (cut_prc_count_VS/population)*100000;
(51 missing values generated)

. gen ln_cut_prc_VS=ln(cut_prc_VS_rate);
(428 missing values generated)

.     ** Firearm accidents;
. generate firearm_VS_rate= (firearm_count_VS/population)*100000;
(51 missing values generated)

. gen ln_firearm_VS=ln(firearm_VS_rate);
(99 missing values generated)

.     ** Machinery accidents;
. generate machinery_VS_rate= (machinery_count_VS/population)*100000;
(51 missing values generated)

. gen ln_machinery_VS=ln(machinery_VS_rate);
(87 missing values generated)

.     ** Natural disaster and environmental accidents;
. generate natural_D_VS_rate= (natural_D_count_VS/population)*100000;
(51 missing values generated)

. gen ln_natural_D_VS=ln(natural_D_VS_rate);
(58 missing values generated)

.     ** Overexertion accidents;
. generate overexert_VS_rate= (overexert_count_VS/population)*100000;
(51 missing values generated)

. gen ln_overexert_VS=ln(overexert_VS_rate);
(922 missing values generated)

.     ** Struck by or against objects accidents;
. generate struck_by_VS_rate= (struck_by_count_VS/population)*100000;
(51 missing values generated)

. gen ln_struck_by_VS=ln(struck_by_VS_rate);
(76 missing values generated)

. ** Janet does not want me to have the logs of 0's be missing values - she wants me to replace the logs of 0's with the logs of 0.00
> 1, so we don't throw out observations;
. foreach i in ln_fall_VS ln_drowning_VS ln_suffocate_VS ln_fire_burn_VS ln_poisonNotOD_VS ln_poisonOther_VS ln_poisonGas_VS ln_o_trn
> sprt_VS ln_adverseFX_VS ln_cut_prc_VS ln_firearm_VS ln_machinery_VS ln_natural_D_VS ln_overexert_VS ln_struck_by_VS {;
  2.         replace `i'=ln(0.001) if (`i'==. & year!=2005);
  3.                 sum `i';
  4.         };
(0 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
  ln_fall_VS |      1224    1.701024    .3004693   .4330778   2.673274
(1 real change made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_drownin~S |      1224    .4008362    .5168555  -6.907755   2.423966
(0 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_suffoca~S |      1224    .6370743    .3319689   -1.09188   1.802234
(1 real change made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_fire_bu~S |      1224    .4170216      .61398  -6.907755   1.840806
(24 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_poisonN~S |      1224   -.7972126    1.055235  -6.907755   1.441237
(125 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_poisonO~S |      1224   -2.251605    1.725006  -6.907755   1.009471
(50 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_poisonG~S |      1224   -1.399885     1.33406  -6.907755   1.269387
(3 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_o_trnsp~S |      1224    .1581195    .6925102  -6.907755   3.081185
(0 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_adverse~S |      1224    .0908902    .4280517  -2.079221   1.294259
(377 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_cut_prc~S |      1224   -4.157031    1.932281  -6.907755  -.6117925
(48 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_firearm~S |      1224    -1.04646    1.464981  -6.907755   2.346946
(36 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_machine~S |      1224   -1.059566      1.2763  -6.907755   1.091343
(7 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_natural~S |      1224    -.412504    .8140627  -6.907755     1.6218
(871 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_overexe~S |      1224   -5.970681    1.545967  -6.907755  -.8446658
(25 real changes made)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
ln_struck_~S |      1224   -.9879244    1.036556  -6.907755   1.062384

. /* Generate state-year control variables used in the regressions from the raw data on control variables    */
> 
> 
> 
> 
> /* First variable to create - hospital beds per capita                                                                             
>              */
> /* Data on hospital beds in the state is not available for every year - so I need to interpolate and extrapolate this data to cover
>  every year  */
> 
> 
> sort statefip;

. by statefip:  ipolate hospbeds year, gen(hospbeds_intp) epolate;

. gen hospbeds_capita = hospbeds_intp/population;

. label variable hospbeds_intp "hospital beds in state missing values interpolated";

. label variable hospbeds_capita "hospbeds_intp over state population";

. /* Data on per capita alcohol consumption is also not available for the year 2005   */
> 
> sort statefip;

. by statefip:  ipolate per_capita_alcohol year, gen(per_capita_alcohol_intp) epolate;

. drop per_capita_alcohol;

. rename per_capita_alcohol_intp per_capita_alcohol;

. label variable per_capita_alcohol "per capita alcohol consumption";

. /* Real per capita income in the state                  */
> 
> gen real_income = (nominal_income/CPI_82_84_base)*100;

. label variable real_income "real per capital income in the state";

. /* Percent of the state population that is African-American     */
> 
> gen prct_Afr_Amer = (pop_total_blacks/population)*100;

. label variable prct_Afr_Amer "percent of state population that is African-American";

. /* Percent of the state population that is Other Minority - which, following the variable definition used by Rubin and Shepherd,   
>   */
> /* is Asians and Native Americans, but not Hispanics                                                                               
>   */ 
> 
> 
> gen prct_other_minority = (pop_other_minority/population)*100;

. label variable prct_other_minority "percent of state population that is other minority";

. /* Percent of the state population that is age 4 or under     */
> 
> gen prct_under_four = (pop_age_0_4/population)*100;

. label variable prct_under_four "percent of state population that is age 4 or younger";

. /* Percent of the state population that is elderly, ie age 65 or above    */
> 
> 
> gen prct_elderly = (pop_65_or_over/population)*100;

. label variable prct_elderly "percentage of state population age 65 or older";

. /* Percent of the state population that are males between the ages of 15 and 24     */
> 
> 
> 
> gen prct_young_males= (pop_males_age_15_to_24/population)*100;

. label variable prct_young_males "percentage of state population that are males between 15 and 24";

. /*  Code to generate dependent variables for the accidental death rates in different age groups                                    
>                    */
> /*  Remember that the accidents in these rates are accidents other than auto accidents and drug overdoses                          
>                    */
> /*  The raw data on these deaths from the Vital Statistics data is already constructed to exclude deaths from auto accidents and dr
> ug overdoses       */
> 
> 
> /* Rate for persons age 0 to 5      */
> 
> gen rate_ages_0_5= (ages_0_to_5_count/ages_0_to_5)*100000;
(51 missing values generated)

. gen ln_rate_ages_0_5 = ln(rate_ages_0_5);
(54 missing values generated)

. replace ln_rate_ages_0_5=0 if rate_ages_0_5==0;
(3 real changes made)

. sum rate_ages_0_5;

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
rate_ages_~5 |      1224    11.59999    5.063683          0    38.5816

. /* Rate for persons age 6 to 17     */
> 
> gen rate_ages_6_17= (ages_6_to_17_count/ages_6_to_17)*100000;
(51 missing values generated)

. gen ln_rate_ages_6_17 = ln(rate_ages_6_17);
(53 missing values generated)

. replace ln_rate_ages_6_17=0 if rate_ages_6_17==0;
(2 real changes made)

. sum rate_ages_6_17;

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
rate_ages~17 |      1224    5.648266    3.195946          0   34.06614

. /*  Rate for persons age 18 to 64    */
> 
> gen rate_ages_18_64= (ages_18_to_64_count/ages_18_to_64)*100000;
(51 missing values generated)

. gen ln_rate_ages_18_64 = ln(rate_ages_18_64);
(51 missing values generated)

. sum rate_ages_18_64;

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
rate_ages~64 |      1224    13.18691    6.590172   4.365676   78.39269

. /*  Rate for persons age 65 and above  */
> 
> gen rate_ages_65_above= (age_65_or_above_count/age_65_or_above)*100000;
(51 missing values generated)

. gen ln_rate_ages_65_above = ln(rate_ages_65_above);
(51 missing values generated)

. sum rate_ages_65_above;

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
rate_ages_~e |      1224    74.12142    17.07137   35.82673   201.2856

. compress;
sy1 was float now byte
sy2 was float now byte
sy4 was float now byte
sy5 was float now byte
sy6 was float now byte
sy8 was float now byte
sy9 was float now byte
sy10 was float now byte
sy11 was float now byte
sy12 was float now byte
sy13 was float now byte
sy15 was float now byte
sy16 was float now byte
sy17 was float now byte
sy18 was float now byte
sy19 was float now byte
sy20 was float now byte
sy21 was float now byte
sy22 was float now byte
sy23 was float now byte
sy24 was float now byte
sy25 was float now byte
sy26 was float now byte
sy27 was float now byte
sy28 was float now byte
sy29 was float now byte
sy30 was float now byte
sy31 was float now byte
sy32 was float now byte
sy33 was float now byte
sy34 was float now byte
sy35 was float now byte
sy36 was float now byte
sy37 was float now byte
sy38 was float now byte
sy39 was float now byte
sy40 was float now byte
sy41 was float now byte
sy42 was float now byte
sy44 was float now byte
sy45 was float now byte
sy46 was float now byte
sy47 was float now byte
sy48 was float now byte
sy49 was float now byte
sy50 was float now byte
sy51 was float now byte
sy53 was float now byte
sy54 was float now byte
sy55 was float now byte
sy56 was float now byte
st1 was float now byte
st2 was float now byte
st4 was float now byte
st5 was float now byte
st6 was float now byte
st8 was float now byte
st9 was float now byte
st10 was float now byte
st11 was float now byte
st12 was float now byte
st13 was float now byte
st15 was float now byte
st16 was float now byte
st17 was float now byte
st18 was float now byte
st19 was float now byte
st20 was float now byte
st21 was float now byte
st22 was float now byte
st23 was float now byte
st24 was float now byte
st25 was float now byte
st26 was float now byte
st27 was float now byte
st28 was float now byte
st29 was float now byte
st30 was float now byte
st31 was float now byte
st32 was float now byte
st33 was float now byte
st34 was float now byte
st35 was float now byte
st36 was float now byte
st37 was float now byte
st38 was float now byte
st39 was float now byte
st40 was float now byte
st41 was float now byte
st42 was float now byte
st44 was float now byte
st45 was float now byte
st46 was float now byte
st47 was float now byte
st48 was float now byte
st49 was float now byte
st50 was float now byte
st51 was float now byte
st53 was float now byte
st54 was float now byte
st55 was float now byte
st56 was float now byte
o_nedcap was float now byte
m_nedcap was float now byte
m_dcap was float now byte
o_jsl_0 was float now byte
m_jsl_0 was float now byte
o_jsl_0_auto was float now byte
o_csr was float now byte
m_csr was float now byte
m_nedcap_2 was float now byte
o_nedcap_2 was float now byte
mms_nedcap was float now byte
no_fault_auto_any was float now byte
o_ned_year was float now byte
o_nedcap_yr2 was float now byte
m_ned_year was float now byte
m_nedcap_yr2 was float now byte
mms_nedcap_yr2 was float now byte
o_nedcap_new was float now byte
m_nedcap_new was float now byte
mms_nedcap_new was float now byte
o_nedcap_yr3 was float now byte
m_nedcap_yr3 was float now byte
o_nedcap_yr4 was float now byte
m_nedcap_yr4 was float now byte
mms_nedcap_yr3 was float now byte
mms_nedcap_yr4 was float now byte
o_nedcap_new3 was float now byte
m_nedcap_new3 was float now byte
mms_nedcap_new3 was float now byte
o_nedcap_new4 was float now byte
m_nedcap_new4 was float now byte
mms_nedcap_new4 was float now byte
o_nedcap_year_lead was float now byte
o_nedcap_lead_2 was float now byte
m_nedcap_year_lead was float now byte
m_nedcap_lead_2 was float now byte
mms_nedcap_lead_2 was float now byte
o_pd_year was float now int
o_pdcap_yr2 was float now byte
o_pdcap_new was float now byte
o_pdcap_yr3 was float now byte
o_pdcap_new3 was float now byte
o_pdcap_yr4 was float now byte
o_pdcap_new4 was float now byte
o_pdcap_year_lead was float now byte
o_pdcap_lead_2 was float now byte
o_pdev_year was float now byte
o_pdev_yr2 was float now byte
o_pdev_new was float now byte
o_pdev_yr3 was float now byte
o_pdev_new3 was float now byte
o_pdev_yr4 was float now byte
o_pdev_new4 was float now byte
o_pdev_year_lead was float now byte
o_pdev_lead_2 was float now byte
o_pdr_year was float now int
o_pd_reform_yr2 was float now byte
o_pd_reform_new was float now byte
o_pd_reform_yr3 was float now byte
o_pd_reform_new3 was float now byte
o_pd_reform_yr4 was float now byte
o_pd_reform_new4 was float now byte
o_pdr_year_lead was float now byte
o_pd_reform_lead_2 was float now byte
o_csr_year was float now byte
o_csr_yr2 was float now byte
o_csr_new was float now byte
o_csr_yr3 was float now byte
o_csr_new3 was float now byte
o_csr_yr4 was float now byte
o_csr_new4 was float now byte
o_csr_year_lead was float now byte
o_csr_lead_2 was float now byte
o_jsl_0_year was float now int
o_jsl_0_new was float now byte
o_jsl_0_yr2 was float now byte
o_jsl_0_yr3 was float now byte
o_jsl_0_new3 was float now byte
o_jsl_0_yr4 was float now byte
o_jsl_0_new4 was float now byte
o_jsl_0_year_lead was float now byte
o_jsl_0_lead_2 was float now byte

. sort statefip year;

. /* This program has now generated all of the variables needed for the regressions - the data set can now be saved under a new name 
>   */  
> 
> 
> save "/hmt/hpcstorage1/hpc/sscc/work/projects/ccm/CCM/CCM-RAND_for_posting_on_Dataverse/data/cleaned_data_for_regressions/Clean_Dat
> a_Deaths.dta", replace;
(note: file /hmt/hpcstorage1/hpc/sscc/work/projects/ccm/CCM/CCM-RAND_for_posting_on_Dataverse/data/cleaned_data_for_regressions/Clean
> _Data_Deaths.dta not found)
file /hmt/hpcstorage1/hpc/sscc/work/projects/ccm/CCM/CCM-RAND_for_posting_on_Dataverse/data/cleaned_data_for_regressions/Clean_Data_D
> eaths.dta saved

. /* Now, generate the Summary Statistics for all of the variables I have                                                       */
> /* These commands are to make Summary Statistics for Table 4 in the paper                                                     */
> 
> /* I need summary statistics weighted by state-year populations, for the years 1981-2004, the years of data for the paper     */
> 
> drop if year>2004;
(51 observations deleted)

. drop if year<1981;
(0 observations deleted)

. sum year;

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        year |      1224      1992.5    6.925016       1981       2004

. summarize [aweight = population];

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
       state |       0           0
    state_ab |       0           0
    statefip |    1224  6.1960e+09    27.73748   15.73273          1         56
        year |    1224  6.1960e+09    1993.018   6.931214       1981       2004
     o_pdcap |    1224  6.1960e+09    .3323973   .4712651          0          1
-------------+-----------------------------------------------------------------
o_pdcap_en~t |     372  2.0595e+09    1960.093   41.41726       1876       2004
o_pdcap_en~d |     276  1.2263e+09    1996.202    6.36391       1985       2005
      o_pdev |    1224  6.1960e+09    .3941823   .4888741          0          1
o_pd_ev_en~t |     479  2.4424e+09     1988.85   5.618112       1973       2004
o_pd_ev_en~d |     313  1.5736e+09    1994.112   4.935035       1983       2004
-------------+-----------------------------------------------------------------
 o_pd_reform |    1224  6.1960e+09    .5882869   .4923449          0          1
o_pd_refor~t |     693  3.6451e+09    1971.445   33.81055       1876       2004
o_pd_refor~d |     291  1.2721e+09    1991.348   4.751684       1983       2004
     m_pdcap |    1224  6.1960e+09    .4012419   .4903502          0          1
m_pdcap_en~t |     425  2.4861e+09    1965.207   39.38703       1876       2004
-------------+-----------------------------------------------------------------
m_pdcap_en~d |     319  1.5655e+09     1995.82   6.021218       1985       2005
      m_pdev |    1224  6.1960e+09    .3941823   .4888741          0          1
m_pdev_enact |     479  2.4424e+09     1988.85   5.618112       1973       2004
m_pd_ev_en~d |     313  1.5736e+09    1994.112   4.935035       1983       2004
    m_dcapex |      98   401834717    .1555153   .3642584          0          1
-------------+-----------------------------------------------------------------
m_dcap_enact |      98   401834717    1978.303   4.960634       1975       1989
m_dcap_ena~d |      20    43962593    1988.152   1.014132       1987       1989
o_nedcap_e~t |     130   358490829    1988.325   2.861333       1986       1997
o_nedcap_e~d |      98   403933788    1994.469   5.958807       1986       2005
m_nedcap_e~t |     376  2.2588e+09    1982.406   6.777558       1975       2004
-------------+-----------------------------------------------------------------
m_nedcap_e~d |     256  1.2777e+09    1997.863   7.334775       1986       2005
     o_jsled |    1224  6.1960e+09    .2863561   .4236556          0          1
    o_jslned |    1224  6.1960e+09    .4959596   .4557408          0          1
o_jsl_p_at~t |    1224  6.1960e+09    .1101705   .3132301          0          1
o_jsl_0_en~t |     677  3.8042e+09    1984.089   15.51766       1888       2003
-------------+-----------------------------------------------------------------
o_jsl_0_en~d |     283  1.4896e+09    1992.698   7.379822       1982       2005
     m_jsled |    1224  6.1960e+09    .1817281   .3445927          0          1
    m_jslned |    1224  6.1960e+09    .3562065   .4329158          0          1
m_jsl_0_en~t |     530  2.8777e+09    1984.357   17.82794       1888       2003
m_jsl_0_en~d |     279  1.5834e+09    1993.633   6.562444       1982       2003
-------------+-----------------------------------------------------------------
   o_csr_off |    1224  6.1960e+09    .2225547   .4161317          0          1
    o_csr_ev |    1224  6.1960e+09    .0248012   .1555824          0          1
 o_csr_enact |     226  1.5326e+09    1987.477   1.624005       1986       2001
o_csr_enac~d |     136   806206762     1990.88   6.536055       1986       2005
  o_csrp_off |    1224  6.1960e+09    .0349737   .1837882          0          1
-------------+-----------------------------------------------------------------
   o_csrp_ev |    1224  6.1960e+09    .0133446   .1147922          0          1
o_csrp_enact |      57   299381929    1988.528   3.310655       1987       2001
o_csrp_ena~d |      51   217211334     1990.16   4.108045       1987       2001
   m_csr_off |    1224  6.1960e+09    .2911692    .454487          0          1
    m_csr_ev |    1224  6.1960e+09    .1697787   .3755917          0          1
-------------+-----------------------------------------------------------------
 m_csr_enact |     437  2.8561e+09     1981.89   6.453099       1975       2004
m_csr_enac~d |     186   971848905    1995.291   7.654555       1983       2004
  m_csrp_off |    1224  6.1960e+09    .0863257   .2809592          0          1
   m_csrp_ev |    1224  6.1960e+09    .1790403   .3835427          0          1
m_csrp_enact |     226  1.6442e+09    1979.035   5.903642       1975       2001
-------------+-----------------------------------------------------------------
m_csrp_ena~d |      81   276456472    1992.627    6.18893       1987       2005
no_fault_a~n |    1224  6.1960e+09    .2137509   .4101205          0          1
no_fault_a~r |    1224  6.1960e+09    .3351432   .4722334          0          1
compulsory~o |    1224  6.1960e+09    .7767401   .4166014          0          1
with_auto_~w |    1224  6.1960e+09     37.4386   7.955069      19.83      89.61
-------------+-----------------------------------------------------------------
just_auto_~w |    1224  6.1960e+09    17.36466   5.167735       6.31      49.01
drug_OD_co~t |    1224  6.1960e+09    422.1998   541.2234          1       2424
     OD_rate |    1224  6.1960e+09    3.066327    2.33255    .097284   16.92163
OD_rate_WI~p |    1224  6.1960e+09    3.051872   2.326839   .1436821   17.02438
Population~S |    1224  6.1960e+09    1.13e+07    8961704     418488   3.56e+07
-------------+-----------------------------------------------------------------
not_at_hos~t |    1224  6.1960e+09    1053.424    665.347         26       2738
at_hosp_co~t |    1224  6.1960e+09     631.494   411.0879          8       1673
not_at_hos~e |    1224  6.1960e+09    10.40997   2.347921    5.40857   29.39339
at_hosp_rate |    1224  6.1960e+09    6.621928   2.717365   1.337633   51.61598
fall_count~S |    1224  6.1960e+09    533.6698   357.7468          9       1636
-------------+-----------------------------------------------------------------
drowning_c~S |    1224  6.1960e+09    167.4938   152.9817          0        670
suffocate_~S |    1224  6.1960e+09    171.4174   100.3874          2        404
fire_burn_~S |    1224  6.1960e+09    156.4083   96.90756          0        422
poisonNotO~S |    1224  6.1960e+09      46.749   30.73274          0        158
poisonOthe~S |    1224  6.1960e+09    19.03678    17.4823          0        104
-------------+-----------------------------------------------------------------
poisonGas_~S |    1224  6.1960e+09    27.71222   19.70965          0        125
o_trnsprt_~S |    1224  6.1960e+09    124.1735   110.7466          0        509
adverseFX_~S |    1224  6.1960e+09    112.3004   74.88551          1        327
cut_prc_co~S |    1224  6.1960e+09    4.413783   4.200257          0         19
firearm_co~S |    1224  6.1960e+09    46.11104   45.11089          0        244
-------------+-----------------------------------------------------------------
machinery_~S |    1224  6.1960e+09    33.99767   22.38563          0        118
natural_D_~S |    1224  6.1960e+09    53.65184   33.11342          0        184
overexert_~S |    1224  6.1960e+09    1.027674   1.761535          0         11
struck_by_~S |    1224  6.1960e+09    35.65732   23.02182          0        122
    hospbeds |     561  2.9725e+09    43302.24   30136.84       1676     115845
-------------+-----------------------------------------------------------------
  unemp_rate |    1224  6.1960e+09    6.170002   1.952685        2.3       17.4
nominal_in~e |    1224  6.1960e+09    22114.83   7260.116       7849      50240
CPI_82_84_~e |    1224  6.1960e+09    142.4451   29.76211       90.9      188.9
pop_total_~s |    1224  6.1960e+09     1324038   929936.8       1254    3369243
pop_other_~y |    1224  6.1960e+09    645217.5    1144338       2843    4874394
-------------+-----------------------------------------------------------------
 pop_age_0_4 |    1224  6.1960e+09    835555.1   720597.9      27300    2829617
pop_65_or_~r |    1224  6.1960e+09     1352565    1001346      12499    3807522
pop_males~24 |    1224  6.1960e+09    856515.9   698218.3      27788    2723794
  population |    1224  6.1960e+09    1.12e+07    8939001     418493   3.58e+07
 ages_0_to_5 |    1224  6.1960e+09    999553.4   859973.4      33320    3350155
-------------+-----------------------------------------------------------------
ages_6_to_17 |    1224  6.1960e+09     1927828    1560352      61970    6405144
ages_18_t~64 |    1224  6.1960e+09     6942937    5572104     270131   2.25e+07
age_65_or_~e |    1224  6.1960e+09     1352561    1001345      12499    3807522
ages_0_to_~t |    1224  6.1960e+09    98.10176   77.41712          0        372
ages_6_to_~t |    1224  6.1960e+09    80.76683   57.36047          0        272
-------------+-----------------------------------------------------------------
ages_18_to~t |    1224  6.1960e+09    708.4724   501.3791         25       2179
age_65_or_~t |    1224  6.1960e+09    798.6377   469.1164          9       2044
         sy1 |    1224  6.1960e+09    .1919219   1.736571          0         23
         sy2 |    1224  6.1960e+09    .0270476   .6576968          0         23
         sy4 |    1224  6.1960e+09    .2057342   1.836569          0         23
-------------+-----------------------------------------------------------------
         sy5 |    1224  6.1960e+09    .1134225   1.341748          0         23
         sy6 |    1224  6.1960e+09    1.444356   4.602992          0         23
         sy8 |    1224  6.1960e+09    .1761693   1.687245          0         23
         sy9 |    1224  6.1960e+09    .1487805    1.52673          0         23
        sy10 |    1224  6.1960e+09    .0330354   .7294726          0         23
-------------+-----------------------------------------------------------------
        sy11 |    1224  6.1960e+09    .0261218   .6362003          0         23
        sy12 |    1224  6.1960e+09    .6623599   3.220329          0         23
        sy13 |    1224  6.1960e+09    .3385946   2.327239          0         23
        sy15 |    1224  6.1960e+09    .0526463   .9149333          0         23
        sy16 |    1224  6.1960e+09    .0537899   .9345097          0         23
-------------+-----------------------------------------------------------------
        sy17 |    1224  6.1960e+09    .5380859   2.873284          0         23
        sy18 |    1224  6.1960e+09    .2623603   2.026308          0         23
        sy19 |    1224  6.1960e+09    .1278291   1.414624          0         23
        sy20 |    1224  6.1960e+09    .1164826   1.355233          0         23
        sy21 |    1224  6.1960e+09    .1746948   1.657286          0         23
-------------+-----------------------------------------------------------------
        sy22 |    1224  6.1960e+09    .1952352   1.743463          0         23
        sy23 |    1224  6.1960e+09    .0559325   .9398163          0         23
        sy24 |    1224  6.1960e+09    .2281545   1.897969          0         23
        sy25 |    1224  6.1960e+09    .2752931   2.069697          0         23
        sy26 |    1224  6.1960e+09    .4337274   2.586261          0         23
-------------+-----------------------------------------------------------------
        sy27 |    1224  6.1960e+09    .2102007   1.822211          0         23
        sy28 |    1224  6.1960e+09    .1222087    1.38877          0         23
        sy29 |    1224  6.1960e+09    .2416552   1.946493          0         23
        sy30 |    1224  6.1960e+09    .0388518   .7857973          0         23
        sy31 |    1224  6.1960e+09    .0740574   1.081598          0         23
-------------+-----------------------------------------------------------------
        sy32 |    1224  6.1960e+09    .0764928   1.138929          0         23
        sy33 |    1224  6.1960e+09     .052756   .9191047          0         23
        sy34 |    1224  6.1960e+09    .3633479   2.377052          0         23
        sy35 |    1224  6.1960e+09    .0763476   1.107328          0         23
        sy36 |    1224  6.1960e+09    .8235404   3.514296          0         23
-------------+-----------------------------------------------------------------
        sy37 |    1224  6.1960e+09    .3350708   2.305977          0         23
        sy38 |    1224  6.1960e+09    .0285308    .666913          0         23
        sy39 |    1224  6.1960e+09    .4984303   2.760642          0         23
        sy40 |    1224  6.1960e+09    .1490366   1.530418          0         23
        sy41 |    1224  6.1960e+09    .1437799   1.517919          0         23
-------------+-----------------------------------------------------------------
        sy42 |    1224  6.1960e+09    .5392851   2.864964          0         23
        sy44 |    1224  6.1960e+09    .0454433   .8472989          0         23
        sy45 |    1224  6.1960e+09    .1701933   1.644822          0         23
        sy46 |    1224  6.1960e+09    .0327075   .7195365          0         23
        sy47 |    1224  6.1960e+09    .2401213   1.949372          0         23
-------------+-----------------------------------------------------------------
        sy48 |    1224  6.1960e+09    .8723355   3.660542          0         23
        sy49 |    1224  6.1960e+09    .0922406   1.224294          0         23
        sy50 |    1224  6.1960e+09    .0262621   .6460736          0         23
        sy51 |    1224  6.1960e+09    .3017094   2.182289          0         23
        sy53 |    1224  6.1960e+09    .2473139    1.98687          0         23
-------------+-----------------------------------------------------------------
        sy54 |    1224  6.1960e+09    .0809238   1.121904          0         23
        sy55 |    1224  6.1960e+09    .2316682   1.906709          0         23
        sy56 |    1224  6.1960e+09    .0215724   .5832032          0         23
         st1 |    1224  6.1960e+09    .0162183   .1263659          0          1
         st2 |    1224  6.1960e+09    .0022174   .0470562          0          1
-------------+-----------------------------------------------------------------
         st4 |    1224  6.1960e+09    .0158531   .1249583          0          1
         st5 |    1224  6.1960e+09      .00953   .0971951          0          1
         st6 |    1224  6.1960e+09    .1176805   .3223612          0          1
         st8 |    1224  6.1960e+09    .0141709   .1182434          0          1
         st9 |    1224  6.1960e+09    .0127298   .1121519          0          1
-------------+-----------------------------------------------------------------
        st10 |    1224  6.1960e+09    .0027053    .051963          0          1
        st11 |    1224  6.1960e+09    .0023289   .0482224          0          1
        st12 |    1224  6.1960e+09    .0527229    .223571          0          1
        st13 |    1224  6.1960e+09    .0271005   .1624426          0          1
        st15 |    1224  6.1960e+09    .0043874   .0661193          0          1
-------------+-----------------------------------------------------------------
        st16 |    1224  6.1960e+09    .0043554   .0658781          0          1
        st17 |    1224  6.1960e+09    .0457985   .2091333          0          1
        st18 |    1224  6.1960e+09    .0222169   .1474486          0          1
        st19 |    1224  6.1960e+09    .0110463    .104562          0          1
        st20 |    1224  6.1960e+09     .009868    .098887          0          1
-------------+-----------------------------------------------------------------
        st21 |    1224  6.1960e+09    .0148399   .1209611          0          1
        st22 |    1224  6.1960e+09    .0168841   .1288898          0          1
        st23 |    1224  6.1960e+09    .0047447   .0687466          0          1
        st24 |    1224  6.1960e+09    .0189219   .1363049          0          1
        st25 |    1224  6.1960e+09    .0234865   .1515046          0          1
-------------+-----------------------------------------------------------------
        st26 |    1224  6.1960e+09    .0368982    .188589          0          1
        st27 |    1224  6.1960e+09    .0175464   .1313491          0          1
        st28 |    1224  6.1960e+09    .0103697   .1013437          0          1
        st29 |    1224  6.1960e+09    .0204081   .1414494          0          1
        st30 |    1224  6.1960e+09    .0032845     .05724          0          1
-------------+-----------------------------------------------------------------
        st31 |    1224  6.1960e+09    .0063142    .079243          0          1
        st32 |    1224  6.1960e+09    .0055843     .07455          0          1
        st33 |    1224  6.1960e+09    .0043409   .0657694          0          1
        st34 |    1224  6.1960e+09    .0307276   .1726492          0          1
        st35 |    1224  6.1960e+09    .0062418   .0787901          0          1
-------------+-----------------------------------------------------------------
        st36 |    1224  6.1960e+09    .0705253   .2561348          0          1
        st37 |    1224  6.1960e+09     .027301   .1630256          0          1
        st38 |    1224  6.1960e+09    .0025107   .0500639          0          1
        st39 |    1224  6.1960e+09    .0427601   .2023985          0          1
        st40 |    1224  6.1960e+09     .012738   .1121874          0          1
-------------+-----------------------------------------------------------------
        st41 |    1224  6.1960e+09    .0117613   .1078538          0          1
        st42 |    1224  6.1960e+09    .0464939   .2106382          0          1
        st44 |    1224  6.1960e+09     .003879   .0621865          0          1
        st45 |    1224  6.1960e+09    .0140788   .1178641          0          1
        st46 |    1224  6.1960e+09    .0027865   .0527348          0          1
-------------+-----------------------------------------------------------------
        st47 |    1224  6.1960e+09    .0199254   .1398011          0          1
        st48 |    1224  6.1960e+09    .0707726   .2565494          0          1
        st49 |    1224  6.1960e+09    .0073856   .0856566          0          1
        st50 |    1224  6.1960e+09    .0022067   .0469427          0          1
        st51 |    1224  6.1960e+09    .0248146   .1556235          0          1
-------------+-----------------------------------------------------------------
        st53 |    1224  6.1960e+09    .0199902   .1400237          0          1
        st54 |    1224  6.1960e+09    .0071337    .084194          0          1
        st55 |    1224  6.1960e+09    .0195382   .1384636          0          1
        st56 |    1224  6.1960e+09    .0018756   .0432847          0          1
o_nedcap_raw |    1224  6.1960e+09    27498.07   117813.4          0    1000000
-------------+-----------------------------------------------------------------
m_nedcap_raw |    1224  6.1960e+09    150515.7   243794.2          0    1355252
    o_nedcap |    1224  6.1960e+09     .057858   .2335702          0          1
    m_nedcap |    1224  6.1960e+09    .4189239   .4935845          0          1
  m_dcap_raw |    1224  6.1960e+09    63110.67   251472.1          0    1750000
      m_dcap |    1224  6.1960e+09    .0648534   .2463677          0          1
-------------+-----------------------------------------------------------------
     o_jsl_0 |    1224  6.1960e+09     .613972   .4870361          0          1
     m_jsl_0 |    1224  6.1960e+09     .464442   .4989379          0          1
o_jsl_0_auto |    1224  6.1960e+09    .5784918   .4940025          0          1
       o_csr |    1224  6.1960e+09    .2473559   .4316517          0          1
       m_csr |    1224  6.1960e+09    .4609479   .4986763          0          1
-------------+-----------------------------------------------------------------
  m_nedcap_2 |    1224  6.1960e+09    .4189239   .4935845          0          1
  o_nedcap_2 |    1224  6.1960e+09     .057858   .2335702          0          1
  mms_nedcap |    1224  6.1960e+09    .3610659   .4805059          0          1
no_fault_a~y |    1224  6.1960e+09     .548894    .497807          0          1
  o_ned_year |     130   358490829    7.026002    5.45131          0         18
-------------+-----------------------------------------------------------------
o_nedcap_yr2 |    1224  6.1960e+09    .0453345   .2081218          0          1
  m_ned_year |     376  2.2588e+09    11.39118   7.572428          0         29
m_nedcap_yr2 |    1224  6.1960e+09    .3289715   .4700317          0          1
mms_nedca~r2 |    1224  6.1960e+09     .283637    .450947          0          1
o_nedcap_new |    1224  6.1960e+09    .0125235    .111251          0          1
-------------+-----------------------------------------------------------------
m_nedcap_new |    1224  6.1960e+09    .0355793   .1853146          0          1
mms_nedcap~w |    1224  6.1960e+09    .0230558   .1501421          0          1
o_nedcap_yr3 |    1224  6.1960e+09     .039888    .195776          0          1
m_nedcap_yr3 |    1224  6.1960e+09    .3168622   .4654434          0          1
o_nedcap_yr4 |    1224  6.1960e+09    .0370917   .1890638          0          1
-------------+-----------------------------------------------------------------
m_nedcap_yr4 |    1224  6.1960e+09    .3049565   .4605772          0          1
mms_nedca~r3 |    1224  6.1960e+09    .2769742   .4476865          0          1
mms_nedca~r4 |    1224  6.1960e+09    .2678648   .4430278          0          1
o_nedcap_n~3 |    1224  6.1960e+09      .01797   .1328966          0          1
m_nedcap_n~3 |    1224  6.1960e+09    .0476887   .2131938          0          1
-------------+-----------------------------------------------------------------
mms_nedca~w3 |    1224  6.1960e+09    .0297187   .1698795          0          1
o_nedcap_n~4 |    1224  6.1960e+09    .0207663   .1426593          0          1
m_nedcap_n~4 |    1224  6.1960e+09    .0595943   .2368305          0          1
mms_nedca~w4 |    1224  6.1960e+09     .038828   .1932639          0          1
o_nedcap_y~d |      98   403933788    6.409385   5.064245          1         24
-------------+-----------------------------------------------------------------
o_nedcap_l~2 |    1224  6.1960e+09    .0150325   .1217319          0          1
m_nedcap_y~d |     256  1.2777e+09     7.17196   5.508941          1         24
m_nedcap_l~2 |    1224  6.1960e+09    .0432646   .2035353          0          1
mms_nedca~_2 |    1224  6.1960e+09    .0295599   .1694389          0          1
   o_pd_year |     372  2.0595e+09    35.39951   39.87022          0        128
-------------+-----------------------------------------------------------------
 o_pdcap_yr2 |    1224  6.1960e+09    .3015115   .4591019          0          1
 o_pdcap_new |    1224  6.1960e+09    .0308858   .1730791          0          1
 o_pdcap_yr3 |    1224  6.1960e+09    .2878284   .4529358          0          1
o_pdcap_new3 |    1224  6.1960e+09    .0445689   .2064397          0          1
 o_pdcap_yr4 |    1224  6.1960e+09    .2740761   .4462299          0          1
-------------+-----------------------------------------------------------------
o_pdcap_new4 |    1224  6.1960e+09    .0583212   .2344456          0          1
o_pdcap_ye~d |     276  1.2263e+09    7.219967   5.281481          1         24
o_pdcap_le~2 |    1224  6.1960e+09    .0379597   .1911769          0          1
 o_pdev_year |     479  2.4424e+09    8.079442   5.919796          0         31
  o_pdev_yr2 |    1224  6.1960e+09    .3431309   .4749488          0          1
-------------+-----------------------------------------------------------------
  o_pdev_new |    1224  6.1960e+09    .0510514   .2201926          0          1
  o_pdev_yr3 |    1224  6.1960e+09    .3176108   .4657375          0          1
 o_pdev_new3 |    1224  6.1960e+09    .0765715    .266019          0          1
  o_pdev_yr4 |    1224  6.1960e+09    .2910793   .4544457          0          1
 o_pdev_new4 |    1224  6.1960e+09     .103103   .3042177          0          1
-------------+-----------------------------------------------------------------
o_pdev_yea~d |     313  1.5736e+09    6.836603   4.640207          1         23
o_pdev_lea~2 |    1224  6.1960e+09    .0496746   .2173606          0          1
  o_pdr_year |     693  3.6451e+09      24.208   32.80401          0        128
o_pd_refo~r2 |    1224  6.1960e+09    .5373769   .4988048          0          1
o_pd_refor~w |    1224  6.1960e+09      .05091   .2199037          0          1
-------------+-----------------------------------------------------------------
o_pd_refo~r3 |    1224  6.1960e+09    .5119558   .5000614          0          1
o_pd_refo~w3 |    1224  6.1960e+09    .0763311   .2656356          0          1
o_pd_refo~r4 |    1224  6.1960e+09    .4855061   .4999942          0          1
o_pd_refo~w4 |    1224  6.1960e+09    .1027808   .3037965          0          1
o_pdr_year~d |     291  1.2721e+09    5.567347   4.003652          1         23
-------------+-----------------------------------------------------------------
o_pd_refo~_2 |    1224  6.1960e+09    .0498595   .2177435          0          1
  o_csr_year |     226  1.5326e+09    7.925933   5.274589          0         18
   o_csr_yr2 |    1224  6.1960e+09    .2134776   .4099295          0          1
   o_csr_new |    1224  6.1960e+09    .0338783   .1809899          0          1
   o_csr_yr3 |    1224  6.1960e+09    .1966981   .3976646          0          1
-------------+-----------------------------------------------------------------
  o_csr_new3 |    1224  6.1960e+09    .0506578   .2193876          0          1
   o_csr_yr4 |    1224  6.1960e+09     .180837   .3850404          0          1
  o_csr_new4 |    1224  6.1960e+09     .066519   .2492889          0          1
o_csr_year~d |     136   806206762    4.223488   2.488405          1         13
o_csr_lead_2 |    1224  6.1960e+09    .0376975   .1905415          0          1
-------------+-----------------------------------------------------------------
o_jsl_0_year |     677  3.8042e+09    11.51726   15.77855          0        116
 o_jsl_0_new |    1224  6.1960e+09    .0609021   .2392485          0          1
 o_jsl_0_yr2 |    1224  6.1960e+09    .5530699   .4973788          0          1
 o_jsl_0_yr3 |    1224  6.1960e+09    .5237249    .499641          0          1
o_jsl_0_new3 |    1224  6.1960e+09    .0902472   .2866527          0          1
-------------+-----------------------------------------------------------------
 o_jsl_0_yr4 |    1224  6.1960e+09    .4931102   .5001569          0          1
o_jsl_0_new4 |    1224  6.1960e+09    .1208618   .3260999          0          1
o_jsl_0_ye~d |     283  1.4896e+09    6.266256   5.393157          1         24
o_jsl_0_le~2 |    1224  6.1960e+09    .0596389   .2369133          0          1
   deathrate |    1224  6.1960e+09    20.07394    4.02359      11.38      66.67
-------------+-----------------------------------------------------------------
     ln_rate |    1224  6.1960e+09    2.980928     .18991   2.431857   4.199755
ln_auto_rate |    1224  6.1960e+09    2.809511   .3036169   1.842136   3.892024
  ln_OD_rate |    1224  6.1960e+09    .8169219    .811007  -2.330121   2.828593
deathrate_~D |    1224  6.1960e+09    17.00762   3.903517   9.833199   65.47523
ln_rate_no~D |    1224  6.1960e+09    2.807901   .2280117   2.285764   4.181672
-------------+-----------------------------------------------------------------
fall_VS_rate |    1224  6.1960e+09    5.272395   1.535414   1.541996   14.48732
  ln_fall_VS |    1224  6.1960e+09    1.626251   .2623811   .4330778   2.673274
drowning_V~e |    1224  6.1960e+09    1.544001   .7018516          0   11.29055
ln_drownin~S |    1224  6.1960e+09    .3410933   .4340835  -6.907755   2.423966
suffocate_~e |    1224  6.1960e+09    1.810655   .5969685   .3355851   6.063179
-------------+-----------------------------------------------------------------
ln_suffoca~S |    1224  6.1960e+09    .5362653   .3490292   -1.09188   1.802234
fire_burn_~e |    1224  6.1960e+09     1.65136   .8219824          0   6.301614
ln_fire_bu~S |    1224  6.1960e+09    .3859764   .4914053  -6.907755   1.840806
poisonNotO~e |    1224  6.1960e+09    .5037729   .2886994          0   4.225922
ln_poisonN~S |    1224  6.1960e+09    -.841441   .6410508  -6.907755   1.441237
-------------+-----------------------------------------------------------------
poisonOthe~e |    1224  6.1960e+09    .1954957   .1853998          0   2.744148
ln_poisonO~S |    1224  6.1960e+09   -1.990758   1.041717  -6.907755   1.009471
poisonGas_~e |    1224  6.1960e+09    .3082773   .2118157          0   3.558671
ln_poisonG~S |    1224  6.1960e+09    -1.40992   .7991478  -6.907755   1.269387
o_trnsprt_~e |    1224  6.1960e+09    1.173232   .7277904          0    21.7842
-------------+-----------------------------------------------------------------
ln_o_trnsp~S |    1224  6.1960e+09    .0596527   .4361716  -6.907755   3.081185
adverseFX_~e |    1224  6.1960e+09    1.127009   .4072615   .1250275   3.648292
ln_adverse~S |    1224  6.1960e+09    .0517153   .3806222  -2.079221   1.294259
cut_prc_VS~e |    1224  6.1960e+09    .0426078   .0353463          0   .5423778
ln_cut_prc~S |    1224  6.1960e+09   -3.677986   1.353719  -6.907755  -.6117925
-------------+-----------------------------------------------------------------
firearm_VS~e |    1224  6.1960e+09    .4937181    .453664          0    10.4536
ln_firearm~S |    1224  6.1960e+09   -1.055227   .9716389  -6.907755   2.346946
machinery_~e |    1224  6.1960e+09    .3999809   .2824731          0   2.978272
ln_machine~S |    1224  6.1960e+09   -1.166654   .8118561  -6.907755   1.091343
natural_D_~e |    1224  6.1960e+09    .6199277   .3887755          0   5.062192
-------------+-----------------------------------------------------------------
ln_natural~S |    1224  6.1960e+09   -.6304329   .5618479  -6.907755     1.6218
overexert_~e |    1224  6.1960e+09    .0091187   .0167886          0   .4297009
ln_overexe~S |    1224  6.1960e+09   -5.671776   1.436468  -6.907755  -.8446658
struck_by_~e |    1224  6.1960e+09    .3924116   .2200263          0    2.89326
ln_struck_~S |    1224  6.1960e+09   -1.078687   .6009848  -6.907755   1.062384
-------------+-----------------------------------------------------------------
hospbeds_i~p |    1224  6.1960e+09    46977.98   32639.08       1676     124573
hospbeds_c~a |    1224  6.1960e+09    .0045165   .0012904   .0021516   .0134082
per_capita~l |    1224  6.1960e+09    2.347902   .4338458        1.2       5.59
 real_income |    1224  6.1960e+09    15215.52   2509.547   8536.787   26596.08
prct_Afr_A~r |    1224  6.1960e+09    12.41018   8.052978   .2353755   69.95806
-------------+-----------------------------------------------------------------
prct_other~y |    1224  6.1960e+09    4.111521   5.117436   .3997697   64.12973
prct_under~r |    1224  6.1960e+09    7.272761   .7883454   4.787684   13.21522
prct_elderly |    1224  6.1960e+09     12.3692   2.031763   2.912669   18.54977
prct_young~s |    1224  6.1960e+09    7.643086   .8482978   4.913727   10.44557
rate_ages_~5 |    1224  6.1960e+09    10.83852   4.199489          0    38.5816
-------------+-----------------------------------------------------------------
ln_rate_ag~5 |    1224  6.1960e+09    2.302869   .4160659          0   3.652776
rate_ages~17 |    1224  6.1960e+09     4.83866   2.217112          0   34.06614
ln_rate_a~17 |    1224  6.1960e+09    1.479197    .446889  -.6968752   3.528304
rate_ages~64 |    1224  6.1960e+09    11.38405   3.777997   4.365676   78.39269
ln_rate_a~64 |    1224  6.1960e+09    2.388901   .2851724   1.473773   4.361731
-------------+-----------------------------------------------------------------
rate_ages_~e |    1224  6.1960e+09    67.22805   16.74634   35.82673   201.2856
ln_rate_ag~e |    1224  6.1960e+09    4.176972    .251563   3.578694   5.304725

. describe;

Contains data from /hmt/hpcstorage1/hpc/sscc/work/projects/ccm/CCM/CCM-RAND_for_posting_on_Dataverse/data/cleaned_data_for_regression
> s/Clean_Data_Deaths.dta
  obs:         1,224                          
 vars:           337                          17 Jul 2011 15:38
 size:       864,144 (99.6% of memory free)
-------------------------------------------------------------------------------------------------------------------------------------
              storage  display     value
variable name   type   format      label      variable label
-------------------------------------------------------------------------------------------------------------------------------------
state           str14  %14s                   
state_ab        str2   %9s                    
statefip        byte   %10.0g                 
year            int    %10.0g                 
o_pdcap         byte   %10.0g                 
o_pdcap_enact   int    %10.0g                 
o_pdcap_enact~d int    %10.0g                 
o_pdev          byte   %10.0g                 
o_pd_ev_enact   int    %10.0g                 
o_pd_ev_enact~d int    %10.0g                 
o_pd_reform     byte   %10.0g                 
o_pd_reform_e~t int    %10.0g                 
o_pd_reform_e~d int    %10.0g                 
m_pdcap         byte   %10.0g                 
m_pdcap_enact   int    %10.0g                 
m_pdcap_enact~d int    %10.0g                 
m_pdev          byte   %10.0g                 
m_pdev_enact    int    %10.0g                 
m_pd_ev_enact~d int    %10.0g                 
m_dcapex        byte   %10.0g                 
m_dcap_enact    int    %10.0g                 
m_dcap_enact_~d int    %10.0g                 
o_nedcap_enact  int    %10.0g                 
o_nedcap_enac~d int    %10.0g                 
m_nedcap_enact  int    %10.0g                 
m_nedcap_enac~d int    %10.0g                 
o_jsled         double %10.0g                 
o_jslned        double %10.0g                 
o_jsl_p_at_fa~t byte   %10.0g                 
o_jsl_0_enact   int    %10.0g                 
o_jsl_0_enact~d int    %10.0g                 
m_jsled         double %10.0g                 
m_jslned        double %10.0g                 
m_jsl_0_enact   int    %10.0g                 
m_jsl_0_enact~d int    %10.0g                 
o_csr_off       byte   %10.0g                 =1 iff mandatory offset CSR reform
o_csr_ev        byte   %10.0g                 =1 iff discretionary offset CSR reform
o_csr_enact     int    %10.0g                 
o_csr_enact_l~d int    %10.0g                 
o_csrp_off      byte   %10.0g                 
o_csrp_ev       byte   %10.0g                 
o_csrp_enact    int    %10.0g                 
o_csrp_enact_~d int    %10.0g                 
m_csr_off       byte   %10.0g                 =1 iff mandatory offset CSR reform
m_csr_ev        byte   %10.0g                 =1 iff discretionary offset CSR reform
m_csr_enact     int    %10.0g                 
m_csr_enact_l~d int    %10.0g                 
m_csrp_off      byte   %10.0g                 
m_csrp_ev       byte   %10.0g                 
m_csrp_enact    int    %10.0g                 
m_csrp_enact_~d int    %10.0g                 
no_fault_auto~n byte   %10.0g                 
no_fault_auto~r byte   %10.0g                 
compulsory_auto byte   %10.0g                 
with_auto_raw   double %10.0g                 
just_auto_raw   double %10.0g                 
drug_OD_count   int    %10.0g                 
OD_rate         double %10.0g                 rate of fatal drug overdoses per 100,000 state residents
OD_rate_WISQA~p double %10.0g                 
Population_WI~S long   %10.0g                 
not_at_hosp_c~t int    %10.0g                 
at_hosp_count   int    %10.0g                 
not_at_hosp_r~e double %10.0g                 
at_hosp_rate    double %10.0g                 
fall_count_VS   int    %10.0g                 
drowning_coun~S int    %10.0g                 
suffocate_cou~S int    %10.0g                 
fire_burn_cou~S int    %10.0g                 
poisonNotOD_c~S int    %10.0g                 
poisonOther_c~S int    %10.0g                 
poisonGas_cou~S int    %10.0g                 
o_trnsprt_cou~S int    %10.0g                 
adverseFX_cou~S int    %10.0g                 
cut_prc_count~S byte   %10.0g                 
firearm_count~S int    %10.0g                 
machinery_cou~S int    %10.0g                 
natural_D_cou~S int    %10.0g                 
overexert_cou~S byte   %10.0g                 
struck_by_cou~S int    %10.0g                 
hospbeds        long   %10.0g                 
unemp_rate      double %10.0g                 
nominal_income  long   %10.0g                 
CPI_82_84_base  double %10.0g                 
pop_total_bla~s long   %10.0g                 
pop_other_min~y long   %10.0g                 
pop_age_0_4     long   %10.0g                 
pop_65_or_over  long   %10.0g                 
pop_males_ag~24 long   %10.0g                 
population      long   %10.0g                 
ages_0_to_5     long   %10.0g                 
ages_6_to_17    long   %10.0g                 
ages_18_to_64   long   %10.0g                 
age_65_or_above long   %10.0g                 
ages_0_to_5_c~t int    %10.0g                 
ages_6_to_17_~t int    %10.0g                 
ages_18_to_64~t int    %10.0g                 
age_65_or_abo~t int    %10.0g                 
sy1             byte   %9.0g                  
sy2             byte   %9.0g                  
sy4             byte   %9.0g                  
sy5             byte   %9.0g                  
sy6             byte   %9.0g                  
sy8             byte   %9.0g                  
sy9             byte   %9.0g                  
sy10            byte   %9.0g                  
sy11            byte   %9.0g                  
sy12            byte   %9.0g                  
sy13            byte   %9.0g                  
sy15            byte   %9.0g                  
sy16            byte   %9.0g                  
sy17            byte   %9.0g                  
sy18            byte   %9.0g                  
sy19            byte   %9.0g                  
sy20            byte   %9.0g                  
sy21            byte   %9.0g                  
sy22            byte   %9.0g                  
sy23            byte   %9.0g                  
sy24            byte   %9.0g                  
sy25            byte   %9.0g                  
sy26            byte   %9.0g                  
sy27            byte   %9.0g                  
sy28            byte   %9.0g                  
sy29            byte   %9.0g                  
sy30            byte   %9.0g                  
sy31            byte   %9.0g                  
sy32            byte   %9.0g                  
sy33            byte   %9.0g                  
sy34            byte   %9.0g                  
sy35            byte   %9.0g                  
sy36            byte   %9.0g                  
sy37            byte   %9.0g                  
sy38            byte   %9.0g                  
sy39            byte   %9.0g                  
sy40            byte   %9.0g                  
sy41            byte   %9.0g                  
sy42            byte   %9.0g                  
sy44            byte   %9.0g                  
sy45            byte   %9.0g                  
sy46            byte   %9.0g                  
sy47            byte   %9.0g                  
sy48            byte   %9.0g                  
sy49            byte   %9.0g                  
sy50            byte   %9.0g                  
sy51            byte   %9.0g                  
sy53            byte   %9.0g                  
sy54            byte   %9.0g                  
sy55            byte   %9.0g                  
sy56            byte   %9.0g                  
st1             byte   %9.0g                  
st2             byte   %9.0g                  
st4             byte   %9.0g                  
st5             byte   %9.0g                  
st6             byte   %9.0g                  
st8             byte   %9.0g                  
st9             byte   %9.0g                  
st10            byte   %9.0g                  
st11            byte   %9.0g                  
st12            byte   %9.0g                  
st13            byte   %9.0g                  
st15            byte   %9.0g                  
st16            byte   %9.0g                  
st17            byte   %9.0g                  
st18            byte   %9.0g                  
st19            byte   %9.0g                  
st20            byte   %9.0g                  
st21            byte   %9.0g                  
st22            byte   %9.0g                  
st23            byte   %9.0g                  
st24            byte   %9.0g                  
st25            byte   %9.0g                  
st26            byte   %9.0g                  
st27            byte   %9.0g                  
st28            byte   %9.0g                  
st29            byte   %9.0g                  
st30            byte   %9.0g                  
st31            byte   %9.0g                  
st32            byte   %9.0g                  
st33            byte   %9.0g                  
st34            byte   %9.0g                  
st35            byte   %9.0g                  
st36            byte   %9.0g                  
st37            byte   %9.0g                  
st38            byte   %9.0g                  
st39            byte   %9.0g                  
st40            byte   %9.0g                  
st41            byte   %9.0g                  
st42            byte   %9.0g                  
st44            byte   %9.0g                  
st45            byte   %9.0g                  
st46            byte   %9.0g                  
st47            byte   %9.0g                  
st48            byte   %9.0g                  
st49            byte   %9.0g                  
st50            byte   %9.0g                  
st51            byte   %9.0g                  
st53            byte   %9.0g                  
st54            byte   %9.0g                  
st55            byte   %9.0g                  
st56            byte   %9.0g                  
o_nedcap_raw    float  %9.0g                  
m_nedcap_raw    float  %9.0g                  
o_nedcap        byte   %9.0g                  =1 if cap on NED applying in all or most types of tort suits in general is in pl
m_nedcap        byte   %9.0g                  
m_dcap_raw      float  %9.0g                  
m_dcap          byte   %9.0g                  
o_jsl_0         byte   %9.0g                   =1 iff [o_jsled>0 | o_jslned>0], ie a JSL reform is in place
m_jsl_0         byte   %9.0g                  
o_jsl_0_auto    byte   %9.0g                  
o_csr           byte   %9.0g                  any generally applicable CSR reform, mandatory or discretionary
m_csr           byte   %9.0g                  any CSR reform that applies in med mal cases, mandatory or discretionary
m_nedcap_2      byte   %9.0g                  
o_nedcap_2      byte   %9.0g                  
mms_nedcap      byte   %9.0g                  =1 iff there is a cap on NED that is specific to med mal
no_fault_auto~y byte   %9.0g                  
o_ned_year      byte   %9.0g                  
o_nedcap_yr2    byte   %9.0g                  
m_ned_year      byte   %9.0g                  
m_nedcap_yr2    byte   %9.0g                  
mms_nedcap_yr2  byte   %9.0g                  
o_nedcap_new    byte   %9.0g                  
m_nedcap_new    byte   %9.0g                  
mms_nedcap_new  byte   %9.0g                  
o_nedcap_yr3    byte   %9.0g                  
m_nedcap_yr3    byte   %9.0g                  
o_nedcap_yr4    byte   %9.0g                  
m_nedcap_yr4    byte   %9.0g                  
mms_nedcap_yr3  byte   %9.0g                  
mms_nedcap_yr4  byte   %9.0g                  
o_nedcap_new3   byte   %9.0g                  
m_nedcap_new3   byte   %9.0g                  
mms_nedcap_new3 byte   %9.0g                  
o_nedcap_new4   byte   %9.0g                  
m_nedcap_new4   byte   %9.0g                  
mms_nedcap_new4 byte   %9.0g                  
o_nedcap_year~d byte   %9.0g                  
o_nedcap_lead_2 byte   %9.0g                  
m_nedcap_year~d byte   %9.0g                  
m_nedcap_lead_2 byte   %9.0g                  
mms_nedcap_le~2 byte   %9.0g                  
o_pd_year       int    %9.0g                  
o_pdcap_yr2     byte   %9.0g                  
o_pdcap_new     byte   %9.0g                  
o_pdcap_yr3     byte   %9.0g                  
o_pdcap_new3    byte   %9.0g                  
o_pdcap_yr4     byte   %9.0g                  
o_pdcap_new4    byte   %9.0g                  
o_pdcap_year_~d byte   %9.0g                  
o_pdcap_lead_2  byte   %9.0g                  
o_pdev_year     byte   %9.0g                  
o_pdev_yr2      byte   %9.0g                  
o_pdev_new      byte   %9.0g                  
o_pdev_yr3      byte   %9.0g                  
o_pdev_new3     byte   %9.0g                  
o_pdev_yr4      byte   %9.0g                  
o_pdev_new4     byte   %9.0g                  
o_pdev_year_l~d byte   %9.0g                  
o_pdev_lead_2   byte   %9.0g                  
o_pdr_year      int    %9.0g                  
o_pd_reform_yr2 byte   %9.0g                  
o_pd_reform_new byte   %9.0g                  
o_pd_reform_yr3 byte   %9.0g                  
o_pd_reform_n~3 byte   %9.0g                  
o_pd_reform_yr4 byte   %9.0g                  
o_pd_reform_n~4 byte   %9.0g                  
o_pdr_year_lead byte   %9.0g                  
o_pd_reform_l~2 byte   %9.0g                  
o_csr_year      byte   %9.0g                  
o_csr_yr2       byte   %9.0g                  
o_csr_new       byte   %9.0g                  
o_csr_yr3       byte   %9.0g                  
o_csr_new3      byte   %9.0g                  
o_csr_yr4       byte   %9.0g                  
o_csr_new4      byte   %9.0g                  
o_csr_year_lead byte   %9.0g                  
o_csr_lead_2    byte   %9.0g                  
o_jsl_0_year    int    %9.0g                  
o_jsl_0_new     byte   %9.0g                  
o_jsl_0_yr2     byte   %9.0g                  
o_jsl_0_yr3     byte   %9.0g                  
o_jsl_0_new3    byte   %9.0g                  
o_jsl_0_yr4     byte   %9.0g                  
o_jsl_0_new4    byte   %9.0g                  
o_jsl_0_year_~d byte   %9.0g                  
o_jsl_0_lead_2  byte   %9.0g                  
deathrate       float  %9.0g                  nonautomotive accidental death rate per 100,000 residents
ln_rate         float  %9.0g                  natural log of deathrate
ln_auto_rate    float  %9.0g                  log of death rate from auto accidents per 100,000 state residents
ln_OD_rate      float  %9.0g                  log of rate of fatal drug overdoses per 100,000 state residents
deathrate_no_OD float  %9.0g                  non-auto non-overdose accidental death rate per 100,000 residents
ln_rate_no_OD   float  %9.0g                  natural log of deathrate_no_OD
fall_VS_rate    float  %9.0g                  
ln_fall_VS      float  %9.0g                  
drowning_VS_r~e float  %9.0g                  
ln_drowning_VS  float  %9.0g                  
suffocate_VS_~e float  %9.0g                  
ln_suffocate_VS float  %9.0g                  
fire_burn_VS_~e float  %9.0g                  
ln_fire_burn_VS float  %9.0g                  
poisonNotOD_V~e float  %9.0g                  
ln_poisonNotO~S float  %9.0g                  
poisonOther_V~e float  %9.0g                  
ln_poisonOthe~S float  %9.0g                  
poisonGas_VS_~e float  %9.0g                  
ln_poisonGas_VS float  %9.0g                  
o_trnsprt_VS_~e float  %9.0g                  
ln_o_trnsprt_VS float  %9.0g                  
adverseFX_VS_~e float  %9.0g                  
ln_adverseFX_VS float  %9.0g                  
cut_prc_VS_rate float  %9.0g                  
ln_cut_prc_VS   float  %9.0g                  
firearm_VS_rate float  %9.0g                  
ln_firearm_VS   float  %9.0g                  
machinery_VS_~e float  %9.0g                  
ln_machinery_VS float  %9.0g                  
natural_D_VS_~e float  %9.0g                  
ln_natural_D_VS float  %9.0g                  
overexert_VS_~e float  %9.0g                  
ln_overexert_VS float  %9.0g                  
struck_by_VS_~e float  %9.0g                  
ln_struck_by_VS float  %9.0g                  
hospbeds_intp   double %10.0g                 hospital beds in state missing values interpolated
hospbeds_capita float  %9.0g                  hospbeds_intp over state population
per_capita_al~l double %10.0g                 per capita alcohol consumption
real_income     float  %9.0g                  real per capital income in the state
prct_Afr_Amer   float  %9.0g                  percent of state population that is African-American
prct_other_mi~y float  %9.0g                  percent of state population that is other minority
prct_under_four float  %9.0g                  percent of state population that is age 4 or younger
prct_elderly    float  %9.0g                  percentage of state population age 65 or older
prct_young_ma~s float  %9.0g                  percentage of state population that are males between 15 and 24
rate_ages_0_5   float  %9.0g                  
ln_rate_ages_~5 float  %9.0g                  
rate_ages_6_17  float  %9.0g                  
ln_rate_ages~17 float  %9.0g                  
rate_ages_18_64 float  %9.0g                  
ln_rate_ages~64 float  %9.0g                  
rate_ages_65_~e float  %9.0g                  
ln_rate_ages_~e float  %9.0g                  
-------------------------------------------------------------------------------------------------------------------------------------
Sorted by:  statefip  year
     Note:  dataset has changed since last saved

. sort o_jsl_0;

. ** Rate of all types of accidental deaths;
. by o_jsl_0: sum with_auto_raw [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
with_auto_~w |     547  2.3918e+09    39.50393   8.382144      19.83      89.61

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
with_auto_~w |     677  3.8042e+09    36.14005    7.38954      22.72      71.96


.  ** Rate of drug overdoses only;
. by o_jsl_0: sum OD_rate [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
     OD_rate |     547  2.3918e+09    1.979057   1.783794    .097284   15.58506

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
     OD_rate |     677  3.8042e+09    3.749936   2.378069    .155873   16.92163


. ** Rate of auto accidents only;
. by o_jsl_0: sum just_auto_raw [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
just_auto_~w |     547  2.3918e+09    18.87209    5.48678       6.31      49.01

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
just_auto_~w |     677  3.8042e+09    16.41688   4.719448       7.44      39.89


. ** Rate excluding auto accidents but including drug overdoses;
. by o_jsl_0: sum deathrate [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
   deathrate |     547  2.3918e+09    20.63184   3.900441      11.38      66.67

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
   deathrate |     677  3.8042e+09    19.72317   4.062562      12.43      52.97


.  ** excluding auto accidents as well as drug overdoses;
. by o_jsl_0: sum deathrate_no_OD [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
deathrate_~D |     547  2.3918e+09    18.65279   3.502899   10.97631   65.47523

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
deathrate_~D |     677  3.8042e+09    15.97323   3.787656   9.833199   50.07732


.  ** rate of accidental deaths excluding auto accidents and overdoses, persons pronounced dead outside of hospitals;
. by o_jsl_0: sum at_hosp_rate [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
at_hosp_rate |     547  2.3918e+09    7.169108   2.630844   1.337633   51.61598

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
at_hosp_rate |     677  3.8042e+09    6.277895   2.716142   2.243437   40.03801


. ** rate of accidental deaths excluding auto accidents and overdoses, persons pronounced dead at hospitals;
. by o_jsl_0: sum not_at_hosp_rate [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
not_at_hos~e |     547  2.3918e+09    11.45404   2.026248   6.115276   29.39339

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
not_at_hos~e |     677  3.8042e+09    9.753528   2.299195    5.40857    21.7257


. ** Rates of accidental deaths excluding auto accidents and overdoses, by age group;
. by o_jsl_0: sum rate_ages_0_5  [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
rate_ages_~5 |     547  2.3918e+09    12.13841   4.498462          0   34.60067

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
rate_ages_~5 |     677  3.8042e+09    10.02124   3.780379          0    38.5816


.  by o_jsl_0: sum rate_ages_6_17 [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
rate_ages~17 |     547  2.3918e+09    5.861815   2.413974          0   34.06614

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
rate_ages~17 |     677  3.8042e+09    4.195363   1.809791          0    22.6584


.  by o_jsl_0: sum rate_ages_18_64 [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
rate_ages~64 |     547  2.3918e+09    12.96475   4.156567   4.365676   78.39269

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
rate_ages~64 |     677  3.8042e+09     10.3902   3.137093   5.155473   61.72717


.  by o_jsl_0: sum rate_ages_65_above [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
rate_ages_~e |     547  2.3918e+09    69.65912   12.61159   39.70228   201.2856

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
rate_ages_~e |     677  3.8042e+09    65.69955   18.73599   35.82673   138.6975


.  ** Summary stats for the state-year level control variables;
. by o_jsl_0: sum unemp_rate [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
  unemp_rate |     547  2.3918e+09    6.710697    2.37192        2.3       17.4

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
  unemp_rate |     677  3.8042e+09    5.830046   1.542266        2.3       12.7


.  by o_jsl_0: sum real_income [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
 real_income |     547  2.3918e+09    14194.19    2443.92   8536.787   26596.08

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
 real_income |     677  3.8042e+09    15857.67   2332.495   9954.819   24235.46


.  by o_jsl_0: sum prct_Afr_Amer [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_Afr_A~r |     547  2.3918e+09    14.23885   9.205332   .2353755   69.95806

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_Afr_A~r |     677  3.8042e+09    11.26042    7.00038   .2432146   36.60975


.  by o_jsl_0: sum prct_other_minority [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_other~y |     547  2.3918e+09    2.531814   3.560492   .3997697   62.54744

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_other~y |     677  3.8042e+09    5.104745   5.670521   .4367105   64.12973


.  by o_jsl_0: sum prct_under_four [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_under~r |     547  2.3918e+09    7.137711   .8069868   4.787684   13.21522

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_under~r |     677  3.8042e+09    7.357672   .7647867   5.283847   11.32224


.  by o_jsl_0: sum prct_elderly [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_elderly |     547  2.3918e+09    12.42985   1.972455   2.912669   17.85818

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_elderly |     677  3.8042e+09    12.33107   2.068553   3.205584   18.54977


.  by o_jsl_0: sum prct_young_males [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_young~s |     547  2.3918e+09    8.051095   .9685351   4.913727   10.44557

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
prct_young~s |     677  3.8042e+09    7.386554   .6422733   5.988807   9.918792


.  by o_jsl_0: sum per_capita_alcohol [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
per_capita~l |     547  2.3918e+09    2.458973   .5096212       1.52       5.59

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
per_capita~l |     677  3.8042e+09    2.278067   .3617741        1.2       4.91


.  by o_jsl_0: sum hospbeds_capita [aweight = population];

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 0

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
hospbeds_c~a |     547  2.3918e+09    .0052584   .0012509   .0026163   .0134082

-------------------------------------------------------------------------------------------------------------------------------------
-> o_jsl_0 = 1

    Variable |     Obs      Weight        Mean   Std. Dev.       Min        Max
-------------+-----------------------------------------------------------------
hospbeds_c~a |     677  3.8042e+09    .0040501   .0010797   .0021516   .0087141


.            log close;
       log:  /hmt/hpcstorage1/hpc/sscc/work/projects/ccm/CCM/CCM-RAND_for_posting_on_Dataverse/log_files/clean_data_log.log
  log type:  text
 closed on:  17 Jul 2011, 15:38:48
-------------------------------------------------------------------------------------------------------------------------------------
